Dashboard and Monitoring

Various system views, a dashboard, and dynamic management views have been added for monitoring (and debugging) the AlwaysOn Availability Groups feature. The AlwaysOn dashboard (right-click the availability group and select Show Dashboard) is used to obtain an at-a-glance view of the health of an AlwaysOn availability group, its availability replicas, and databases.

You can use this dashboard to do the following:

Image Choose a replica for a manual failover.

Image Estimate data loss if you force failover.

Evaluate data-synchronization ...

Get Microsoft SQL Server 2014 Unleashed 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.