Skip to content

modify-a-resource-health-policy-definition-sql-server-utility.md

Latest commit

 

History

History
60 lines (39 loc) · 4.98 KB

modify-a-resource-health-policy-definition-sql-server-utility.md

File metadata and controls

60 lines (39 loc) · 4.98 KB
title Modify a Resource Health Policy Definition (SQL Server Utility) | Microsoft Docs
ms.custom
ms.date 03/14/2017
ms.prod sql
ms.prod_service database-engine
ms.reviewer
ms.technology configuration
ms.topic conceptual
f1_keywords
sql13.SWB.UE.UTILITY.ADMINISTRATION.F1
ms.assetid 27bec0b6-92e9-448e-8c70-fe36802cf128
author MikeRayMSFT
ms.author mikeray

Modify a Resource Health Policy Definition (SQL Server Utility)

[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md] This topic describes how to modify a resource health policy definition in [!INCLUDEssCurrent] by using [!INCLUDEssManStudioFull]. Before you modify a resource utilization policy in your [!INCLUDEssNoVersion] Utility, you must create a utility control point (UCP). For more information, see SQL Server Utility Features and Tasks.

[!INCLUDEssNoVersion] Utility resource utilization policies can be configured for data-tier applications and managed instances of [!INCLUDEssNoVersion]. Resource utilization policies can be defined globally for all data-tier applications and managed instances of [!INCLUDEssNoVersion] in the [!INCLUDEssNoVersion] Utility, or they can be defined individually for each data-tier application and for each managed instance of [!INCLUDEssNoVersion] in the [!INCLUDEssNoVersion] Utility. You can also implement global policies and have individual data-tier applications or managed instances of [!INCLUDEssNoVersion] configured with their own policy definitions.

Using SQL Server Management Studio

Modify global resource utilization policies in a SQL Server Utility.

  1. Connect to the UCP in [!INCLUDEssManStudio].

  2. In the Utility Explorer navigation pane, click Utility Administration to view or modify global monitoring policies, then click the Policy tab in the Utility Explorer content pane.

  3. In the Utility Explorer content pane, select Set global data-tier monitoring policies or Set global managed instance monitoring policies by clicking on the arrow or the policy description.

  4. Use the controls on the right side of the policy descriptions to set underutilization or overutilization policy thresholds.

  5. Use the Apply, Discard, or Restore Default buttons as needed. The policy change can take up to 15 minutes to propagate back to the [!INCLUDEssNoVersion] Utility dashboard and list view details.

  6. To refresh data, right-click on the Utility Administration node in the Utility Explorer navigation pane, and select Refresh.

Modify resource health policy definitions for an individual data-tier application or an individual managed instance of SQL Server in a SQL Server Utility

  1. Connect to the UCP in [!INCLUDEssManStudio].

  2. In the Utility Explorer navigation pane, click Deployed Date-tier Applications, or click Managed Instances, to view or modify monitoring policies for an individual data-tier application or managed instance.

  3. In the Utility Explorer content pane list view, click the data-tier application or [!INCLUDEssNoVersion] instance name whose policies you would like to modify, then click on the Policy Details tab.

  4. Select the policy to view or modify by clicking on the arrow or the policy description. Global policies are selected by default.

  5. Select the radio button to Override the global policy to override global policies and implement an individual policy definition for the specified data-tier application.

  6. Use the controls on the right side of the policy description to set underutilization or overutilization policy thresholds.

  7. Use the Apply, Discard, or Restore Default buttons as needed. The policy change can take up to 15 minutes to propagate back to the [!INCLUDEssNoVersion] Utility dashboard and list view details.

  8. To refresh data, right-click on the Deployed Data-tier Applications node in the Utility Explorer navigation pane, and select Refresh.

See Also

SQL Server Utility Features and Tasks
View Resource Health Policy Results (SQL Server Utility)