Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Automating SQL Server Always On Availability Groups Health Checks
Introduction
What this training is all about (8:58)
How to get the most out of this training course (13:33)
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 (19:22)
Automating the Health Checks (20:06)
Using Your Action Items for Your Next Performance Review (12:49)
Summary (8:04)
Using Your Action Items for Your Next Performance Review
Complete and Continue