Autoplay
Autocomplete
Previous Lesson
Complete and Continue
SQL Server Always On Failover Clustered Instances: The Senior DBA’s Ultimate Field Guide
Program Introduction
What this training is all about (15:12)
How to get the most out of this training course (19:39)
Windows Server Failover Clustering Fundamentals
What is a high availability cluster? (7:03)
High Availability: Hardware-level, Operating System-level and Application-level (6:34)
3 Common Types of Microsoft® High Availability Clusters for SQL Server Workloads (12:50)
Assessment
The Traffic Light Analogy: How Windows Server Failover Clustering Works (7:01)
Windows Server Failover Clustering Components: Nodes (3:19)
Windows Server Failover Clustering Components: Cluster Resources (9:35)
Windows Server Failover Clustering Components: Shared Disks (6:50)
Windows Server Failover Clustering Components: Resource Groups (5:12)
Failover and Failback (7:14)
Dependencies (5:50)
Windows Server Failover Clustering Components: Quorum (10:52)
Windows Server Failover Clustering Components: Heartbeat (3:30)
The “split brain” Phenomenon (6:34)
Windows Server Failover Clustering Components: Cluster Shared Volumes (13:19)
Planning and Installing a Windows Server Failover Cluster
Hardware Requirements for Installation (20:17)
Active Directory and DNS Requirements for Installation (12:20)
Planning: Asking The Right Questions (22:07)
Cluster Preparation Checklist (4:48)
Configuring Shared Storage and Connectivity a.k.a. Building Your Own SAN (81:46)
Preparing The Servers: Adding the Failover Cluster Feature and Failover Cluster Validation (23:36)
Creating the Windows Server Failover Cluster (6:09)
Granting Permissions in Active Directory (and creating the WSFC afterwards) (19:36)
Pre-staging Virtual Computer Objects in Active Directory (3:18)
Using Windows PowerShell to Validate and Create a WSFC (14:34)
Deep Dive on Windows Server Failover Cluster Quorum
Quick Recap on Quorum (3:25)
Requirements for a Disk Witness (4:40)
Requirements for a File Share Witness (6:46)
Requirements for a Cloud Witness (2:05)
Difference Between Disk Witness and File Share Witness (11:48)
Partition In Time (9:47)
Typical Events Leading Up To Quorum Issues (6:09)
Dynamic Quorum Feature (1:58)
Quorum Behavior with Dynamic Quorum (5:18)
Dynamic Witness Feature (1:32)
Quorum Behavior with Both Dynamic Quorum and Dynamic Witness (6:14)
Dynamic Quorum and Dynamic Witness In Action with a 4-node Windows Server Failover Cluster and a Witness (28:17)
When the Dynamic Quorum and Dynamic Witness Features Might Not Appear To Work (13:51)
Single Data Center versus Multi-Data Center Considerations: Choosing Between Automatic or Manual Failover (4:26)
Single Data Center versus Multi-Data Center Considerations: Choosing a Witness Type (6:44)
Windows Server Failover Cluster Configuration
Introduction (3:58)
How the Create Cluster Wizard Chooses Quorum Configuration (3:30)
Verifying and Modifying Quorum Configuration (19:35)
Understanding Windows Server Failover Cluster Networking (16:05)
Configuring Windows Server Failover Cluster Networking (38:32)
Configuring Windows Server Failover Cluster Storage (35:41)
Testing Failover (11:53)
Understanding Active Directory and DNS Registration Behavior and How It Affects Multi-subnet Windows Server Failover Clusters (20:52)
Configuring DNS Registration Behavior for Multi-subnet Windows Server Failover Clusters (6:36)
Understanding Cluster Heartbeat Settings (20:30)
Configuring Cluster Heartbeat Settings (17:19)
Applying the Concepts of Site-awareness for Multi-Subnet/Site Configuration (40:24)
Assignment (10:52)
Planning and Installing SQL Server Failover Clustered Instance
Introduction (1:51)
SQL Server Failover Clustered Instance Fundamentals (11:50)
Planning: Asking The Right Questions (30:49)
SQL Server Licensing That Will Influence Your Design (12:24)
Time to Update the Cluster Preparation Checklist (4:22)
Installing SQL Server Failover Clustered Instance: The Most Common Way (48:55)
Installing SQL Server Failover Clustered Named Instance with an Existing Default Instance (21:02)
Installing SQL Server Failover Clustered Instance from the Command Prompt (47:57)
Installing SQL Server Failover Clustered Instance on a Volume Mountpoint (27:25)
Installing SQL Server Failover Clustered Instance: The Most Common Way with Cumulative Updates (15:36)
tempdb on Local Disk versus Shared Disk (26:44)
Fixing Installation versus Starting From Scratch (5:12)
SQL Server Analysis Services on a Windows Server Failover Cluster (30:00)
Testing Application Connectivity and Failover (22:11)
Section Assignment (13:07)
Configuring SQL Server Failover Clustered Instances
Introduction (4:57)
Configuring and Accessing Named Instances as a Default Instance (20:36)
SQL Server Failover Clustered Instances as Cluster Resource Groups (5:53)
Understanding Cluster Resource Dependency Behavior (9:05)
Viewing Cluster Resource Dependencies (10:30)
Configuring Resource Group-level Policies (14:47)
Configuring Resource-level Policies (21:15)
To DTC or Not To DTC? (9:55)
Summary (1:52)
Managing SQL Server Failover Clustered Instances
Introduction (2:16)
Flexible Failover Policy in SQL Server Failover Clustered Instances (16:53)
Adding and Removing Clustered Disks (36:19)
Modifying Network-related Resources of a SQL Server Failover Clustered Instance (45:02)
Fixing Installation versus Starting From Scratch - Part 2 (9:51)
Removing a Node From a SQL Server Failover Clustered Instance (8:24)
Evicting a Node From the Windows Server Failover Cluster (8:12)
Installing Service Packs and Cumulative Updates (48:47)
Changing SQL Server service account (18:51)
Monitoring SQL Server Failover Clustered Instances
Windows Server Failover Clustering Internals (21:09)
Understanding sp_server_diagnostics in the context of WSFC Health Detection (7:44)
Windows Server Failover Clustering Internals in Action (37:18)
R.A.P. Monitoring (8:01)
Using dbaTools to do a SQL Server Failover Clustered Instance Health Check (27:57)
Troubleshooting Common Availability Issues in SQL Server Failover Clustered Instances
Workflow Process for Troubleshooting Availability Issues (9:11)
Troubleshooting Failover Clustered Instance Outages: Step 1 (15:40)
Troubleshooting Failover Clustered Instance Outages: Step 2 (12:41)
Troubleshooting Failover Clustered Instance Outages: Step 3 (9:59)
Troubleshooting Failover Clustered Instance Outages: Step 4 (26:13)
Force Start a Failover Cluster Without Quorum (18:43)
Troubleshooting Failover Clustered Instance Outages: Step 5 (8:30)
Troubleshooting Exercise #1 (21:42)
Troubleshooting Exercise #2 (17:49)
Troubleshooting Exercise #3 (26:52)
Configuring Shared Storage and Connectivity a.k.a. Building Your Own SAN
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock