Skip to content

Latest commit

 

History

History
28 lines (21 loc) · 1.94 KB

always-on-policies.md

File metadata and controls

28 lines (21 loc) · 1.94 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic
Use group policies for availability group health
Learn how to view the group system policies that the Always On dashboard uses to provide information about the availability group health.
MashaMSFT
mathoma
06/13/2017
sql
availability-groups
how-to

Evaluate health of the Always On availability group using group policies

[!INCLUDE SQL Server] The Always On availability groups system policies are used by the Always On Dashboard to provide information on the availability group health to the user. They are very useful for initial troubleshooting of an availability group's operational issues. These policies can be extended and used to customize the Always On Dashboard, or run instantly to report the desired health information.

There are 14 system policies for availability groups. For detailed information on each policy, see Always On policies for operational issues with Always On Availability Groups (SQL Server).

View or evaluate availability groups system policies

To view or run the availability groups system policies in SQL Server Management Studio (SSMS), do the following:

  1. In the Object Explorer, expand Management, Policy Management, Policies, and then System Policies.

  2. Right-click one of the policies and click Evaluate. If you want to evaluate the policy you selected, you are done. You can click View in the Target details box to see the details of the evaluation results.

  3. To view all the availability groups system policies, in the Select a page pane, click Policy Selection.

Next steps

The Always On health model, part 2: Extending the health model.