Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Automating SQL Server Always On Availability Groups Health Checks
Introduction
What this training is all about
How to get the most out of this training course
The importance of running regular health checks (7:58)
Tools of the Trade
SQL Server Management Studio (2:40)
Failover Clustering Management Tools (7:43)
Power BI Desktop (2:24)
dbaTools and dbaChecks (14:28)
SQL Server Express Edition (3:11)
What Kinds of Checks?
Failover Cluster-related Checks (7:56)
Networking-related Checks (4:27)
SQL Server-related Checks (6:38)
Availability Group-related Checks (6:39)
High Availability vs Disaster Recovery (7:10)
Using dbaChecks to Run Availability Groups Health Checks
Getting started with dbaChecks (7:49)
Understanding the Different Configuration Checks (11:02)
Setting Values for the Different Configuration Checks (8:25)
Running an Availability Group Health Check (7:48)
Reviewing the Results (24:05)
Combining Recommended Best Practices Checks with Availability Group Health Checks
Reviewing Recommended General Best Practices Checks (10:16)
How to Include Recommended Best Practices Checks with Availability Groups Health Checks (11:43)
Displaying the Results in Fancy Dashboards
Reviewing the dbaChecks Built-in Power BI Dashboard (10:07)
Configuring dbaChecks to display results in a Power BI Dashboard (13:04)
Exploring the Results in Power BI (6:31)
Storing Health Check Results in a SQL Server Database (22:46)
Operationalizing Health Checks and Creating Action Items
Creating a Change Management Process from the Results of the Health Checks
Automating the Health Checks
Using Your Action Items for Your Next Performance Review
Summary
Failover Cluster-related Checks
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock