O'Reilly logo

Microsoft SQL Server 2008 R2 Administration Cookbook by Satya Shyam K Jayanty

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Administrating resource health policies

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required