Microsoft® SQL Server 2012 Unleashed

Introduction to Policy-Based Management

A data explosion has been occurring over the past several years. This data explosion often results in a proliferation of SQL servers, often requiring DBAs to do more, frequently with less. In addition, the increasing complexities of the SQL Server product set are forcing DBAs to focus on efficient, scalable management and standardization. Due to the large numbers of SQL servers involved, management by automation becomes critical as well to lessen the administrative burden. Monitoring also becomes more important to provide proactive support.

A well-managed SQL Server enterprise that follows best practices offers the following advantages:

Standardization—Every SQL Server will have a common disk layout and ...