16.4 Monitoring AlwaysOn availability Groups

Source: Internet
Author: User
Tags failover

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.