Worried and nervous about meeting deadlines on deploying your SQL Server high availability solution? Struggling with lack of confidence on your design? Are outages taking over your personal life that you can no longer focus on the things that really matter?
I've got you covered.
You need to build or manage a SQL Server failover clustered instance (FCI) but you’re not sure where to start. And with Always On Availability Groups as another high availability solution, it becomes even more confusing.
Properly sizing the hardware?
Who is responsible for what?
How does the Windows Server Failover Cluster work with SQL Server?
The SQL Server FCI is not dead. Even though Always On Availability Groups were introduced in SQL Server 2012, customers are still deploying SQL Server FCIs to protect mission-critical databases.
This training is specifically for you.
This online course is specifically designed for senior database administrators and systems engineers responsible for designing, deploying, and managing SQL Server failover clustered instances.
Course Outline
Windows Server Failover Clustering Fundamentals
Available in
days
days
after you enroll
- 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
Available in
days
days
after you enroll
- 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 (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
Available in
days
days
after you enroll
- 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
Available in
days
days
after you enroll
- 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
Available in
days
days
after you enroll
- SQL Server Failover Clustered Instance Fundamentals (11:50)
- Planning: Asking The Right Questions (30:49)
- 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
Available in
days
days
after you enroll
- 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
Available in
days
days
after you enroll
- 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
Available in
days
days
after you enroll
- 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
Available in
days
days
after you enroll
- 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)