Chapter 17. Implementing and Managing Policy-Based Management

Policy-Based Management is one of the most sought after multi-instance management capabilities in SQL Server 2012. It gives an organization the potential to create policies for managing one or more instances of SQL Server, databases, or some other objects within the Database Engine. Policies can be evaluated against target systems to ensure that the standard configuration settings for an instance of SQL Server are not out of compliance. Policy-Based Management was developed in response to the following industry trends:

• Increasing amounts of data being stored

• Data center consolidation and virtualization

• Growing product capabilities

• Proliferation of SQL Server instances within ...

Get Microsoft® SQL Server 2012 Management and Administration, Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.