SQL Server Utility dashboard in SQL Server Management Studio helps monitoring multiple instances and policies for SQL Server instances and data-tier applications (DAC). Using the UCP, health policies can be configured for data-tier applications and managed instances of SQL Server; also, the policies can be defined globally or individually for that DAC or managed instance.
Many a time, over-utilization and under-utilization of policies for managed instances can be a long process. File space for storage volumes and database files together with server processor utilization can be obtained by using UCP resource policies, such as SQL server instance processor utilization. In this recipe, we will go through the important steps in administering the resource health policies using Utility Control Point (UCP).