Autoplay
Autocomplete
Previous Lesson
Complete and Continue
SQL Server Always On Availability Groups: The Senior DBA’s Ultimate Field Guide (PowerShell Edition)
Program Introduction
What this training is all about
How to get the most out of this training course (22:38)
Assumptions
Setting up your DBA workstation
SQL Server Management Studio
Failover Clustering Management Tools
dbaTools
Installing a Windows Server Failover Cluster
Prerequisites
Cluster Preparation Checklist
Preparing The Servers: Adding the Failover Cluster Feature and Failover Cluster Validation
Creating the Windows Server Failover Cluster
Windows Server Failover Cluster Configuration
Verifying and Modifying Quorum Configuration
Configuring Windows Server Failover Cluster Networking
Testing Failover
Configuring DNS Registration Behavior for Multi-subnet Windows Server Failover Clusters (6:36)
Configuring Cluster Heartbeat Settings (17:19)
Applying the Concepts of Site-awareness for Multi-Subnet/Site Configuration (40:24)
Deploying SQL Server Always On Availability Groups
Building a 4-replica SQL Server Availability Group
Viewing Availability Group Properties
Testing Application Connectivity and Availability Group Failover (21:39)
Configuring Dedicated Network for Availability Group Replication Traffic
Configuring a Distributed Availability Group
Conmfiguring Basic Availability Groups
My Favourite Tool for Network Connectivity Testing (18:39)
Configuring SQL Server Always On Availability Groups
Replicating SQL Server Logins
Replicating SQL Server Agent Jobs
Availability Groups as Failover Cluster Resource Groups
Viewing Cluster Resource Dependencies
Configuring Resource Group-level Policies
Configuring Resource-level Policies
Configuring Availability Groups Listener Name DNS settings for Multi-subnet Failover Clusters (16:42)
Configuring Readable Secondary Replicas
Configuring Read-Only Routing
Configuring Load Balancing of Read-Only Workloads
Managing SQL Server Always On Availability Groups
Running Integrity Checks: DBCC CHECKDB (14:35)
Configuring Backup Preferences (8:04)
Adding or Removing a Database in the Availability Group (7:25)
Adding or Removing a Secondary Replica
Modifying Availability/Replication Modes (5:32)
Temporarily Suspending and Resuming Data Synchronization (3:13)
Dealing With Different Database File Paths Between Replicas (5:25)
Performing Planned Manual Failover of Availability Groups (6:20)
Performing Forced Manual Failover of Availability Groups (6:36)
Configuring Flexible Failover Policy
Modifying Session Timeout Period (3:47)
Performing Index Maintenance (7:12)
Managing Statistics (5:49)
Installing Service Packs and Cumulative Updates (54:39)
Monitoring SQL Server Always On Availability Groups
Using dbaTools to do an Always On Availability Group Health Check (15:14)
Troubleshooting Common Issues in SQL Server Always On Availability Groups
Zero Downtime Blueprint (18:59)
Force Start a Failover Cluster Without Quorum (30:30)
Troubleshooting Exercise #1 (9:00)
Troubleshooting Exercise #2 (5:08)
Troubleshooting Exercise #3 (7:49)
Summary (14:45)
Troubleshooting Exercise #3
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock