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 ...