Chapter 18. Policy-based Management
In this chapter we will cover:
- Evaluating database properties
- Restricting database objects
Introduction
Microsoft made database administrators very happy by introducing a feature called Policy-based Management (PBM). PBM helps administrators to manage one or more instances of SQL Server and manage database entities and/or other SQL Server objects, based on the policy defined in PBM. It helps DBAs to apply/enforce policies for server objects and databases, or to manage different tasks effortlessly and effectively.
The following terms will be needed in the recipes coming up in this chapter, so keep them in mind to ensure that you can understand all the recipes properly:
- Policies: Defined rules for the database or server ...
Get Microsoft SQL Server 2012 Performance Tuning Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
