© Peter A. Carter 2020
P. A. CarterSQL Server 2019 AlwaysOnhttps://doi.org/10.1007/978-1-4842-6479-9_10

10. Troubleshooting AlwaysOn

Peter A. Carter1 
(1)
Botley, UK
 

SQL Server exposes a wealth of metadata, pertaining to high availability and disaster recovery objects, especially around the AlwaysOn feature set. This metadata can be used to quickly identify a configuration, find the root cause of an issue, or script automated responses to events that may occur. The following sections will discuss the metadata that is available and provide examples of how it can be used.

AlwaysOn Failover Clustered Instance Metadata

From inside the database engine, it is possible to view a large amount of metadata regarding a clustered instance, and the Windows Cluster ...

Get SQL Server 2019 AlwaysOn: Supporting 24x7 Applications with Continuous Uptime now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.