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

Implementing Policy-Based Management features

One of the best administrative features for DBAs is Policy-Based Management (PBM) that is introduced in SQL Server 2008. PBM has three components such as policy management, explicit administration, and evaluation modes that contain the concepts of targets, facets, and conditions.

The best practices are implemented as policies that are based on a predefined list of SQL Server recommendations as policy files. The evaluation of policies against a target set includes instances, databases, or database objects. The policies are used to determine whether there are potential issues in the database environment or instance meets best practices guidelines and recommendations.

Once a policy or multiple policies ...

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