16.4 Monitoring AlwaysOn availability Groups

16.4 Monitoring AlwaysOn availability Groups

16.4.1 Open the Display panel

In SSMS, select an availability group, right-click it, and then select Display Panel from the context menu.

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/6E/6B/wKiom1V7wXPC1zf8AAO2-VOsZqo757.jpg "title=" Display panel. png "alt=" wkiom1v7wxpc1zf8aao2-voszqo757.jpg "/>

The information displayed on the panel is divided into 3 parts.

The first section shows the basic information for the current availability group, including: Current state, which node the primary instance resides in, failover mode, and cluster state.

The second section is a summary list of availability replicas.

The third section contains a detailed list of availability replicas. You can hide this detailed list by clicking the icon (the up triangle) to the right of Add/Remove columns.

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/6E/67/wKioL1V7wymzqh-eAAXd0rtZmVw915.jpg "title=" Panel details. png "alt=" wkiol1v7wymzqh-eaaxd0rtzmvw915.jpg "/>

Summary lists and detailed lists you can add or remove columns manually. Detailed lists can also be grouped according to some columns.

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/6E/6B/wKiom1V7xKDgeH_xAAQmJU97fI8396.jpg "title=" Add Delete column. png "alt=" wkiom1v7xkdgeh_xaaqmju97fi8396.jpg "/>

16.4.2 Show additional Information

On the right side of the basic information list, there are three links.

The Start Failover Wizard is used to initiate a manual failover.

View AlwaysOn Health Events displays detailed events for the availability group. Only the "name" and "timestamp" two columns are displayed by default. In the details list, right-click a field and select Show columns in table to display the field in the list of events.

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/6E/6B/wKiom1V7xxziV0BSAAVVSnH7Tho311.jpg "title=" Health events. png "alt=" wkiom1v7xxziv0bsaavvsnh7tho311.jpg "/>

View cluster quorum information displays information about all the nodes in WSFC, as well as the type, status, voting count, and so on for each member.

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/6E/6C/wKiom1V7yUnw_49rAAE2MmTl6TY033.jpg "title=" cluster quorum information. png "alt=" wkiom1v7yunw_49raae2mmtl6ty033.jpg "/>

This article from "SQLServer2014 series" blog, declined reprint!

16.4 Monitoring AlwaysOn availability Groups