Skip to content

configure-health-policies-sql-server-utility.md

Latest commit

 

History

History
59 lines (39 loc) · 4.49 KB

configure-health-policies-sql-server-utility.md

File metadata and controls

59 lines (39 loc) · 4.49 KB
title Configure Health Policies (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
ms.assetid 030aac3b-8901-4c41-91ed-aba96420276c
author MikeRayMSFT
ms.author mikeray

Configure Health Policies (SQL Server Utility)

[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md] Use the [!INCLUDEssNoVersion] Utility dashboard in [!INCLUDEssManStudioFull] to view [!INCLUDEssNoVersion] Utility resource parameters for managed instances of [!INCLUDEssNoVersion] and data-tier applications. For more information, see SQL Server Utility Features and Tasks.

To view [!INCLUDEssNoVersion] Utility health policy results, connect to a utility control point from [!INCLUDEssManStudio]. For more information, see Use Utility Explorer to Manage the SQL Server Utility.

[!INCLUDEssNoVersion] Utility health policies can be configured for data-tier applications and managed instances of [!INCLUDEssNoVersion]. Health 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.

Monitoring Policies for Data-tier Applications

Overutilization and underutilization policies for [!INCLUDEssNoVersion] data-tier applications are as follows:

  • Data-tier application processor utilization.

  • Data-tier application file space for database files.

  • Data-tier application file space for storage volumes.

  • Computer processor utilization.

Note

Storage volume and processor utilization are read-only policies for data-tier applications.

For more information about viewing or changing global monitoring policies for data-tier applications, see Utility Administration (SQL Server Utility).

For more information about viewing or changing monitoring policies for individual data-tier applications, see Deployed Data-tier Application Details (SQL Server Utility).

Monitoring Policies for Managed Instances of SQL Server

Overutilization and underutilization policies for managed instances of [!INCLUDEssNoVersion] are as follows:

  • [!INCLUDEssNoVersion] instance processor utilization.

  • [!INCLUDEssNoVersion] instance file space for database files.

  • [!INCLUDEssNoVersion] instance file space for storage volumes.

  • Computer processor utilization.

For more information about viewing or changing global monitoring policies for managed instances of [!INCLUDEssNoVersion], see Utility Administration (SQL Server Utility).

For more information about viewing or changing monitoring policies for individual managed instances of [!INCLUDEssNoVersion], see Managed Instance Details (SQL Server Utility).

See Also

SQL Server Utility Features and Tasks
Reduce Noise in CPU Utilization Policies (SQL Server Utility)