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
Understanding the Different Configuration Checks
Setting Values for the Different Configuration Checks
Running an Availability Group Health Check
Reviewing the Results
Combining Recommended Best Practices Checks with Availability Group Health Checks
Reviewing Recommended Best Practices Checks
How to Include Recommended Best Practices Checks with Availability Groups Health Checks
Displaying the Results in Fancy Dashboards
Reviewing the dbaChecks Built-in Power BI Dashboard
Configuring dbaChecks to display results in a Power BI Dashboard
Exploring the Results in Power BI
Storing Health Check Results in a SQL Server Database
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
Summary
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock