Monitor and Enforce Best Practices by Using Policy-Based Management
Applies to: SQL Server (all supported versions)
Policy-Based Management allows you to monitor best practices for the SQL Server Database Engine. Evaluate policies manually, set policies to evaluate a target set according to a schedule, or set policies to evaluate a target set according to an event. For more information about Policy-Based Management, see Administer Servers by Using Policy-Based Management. A set of sample policy files is available that you can import as best practice policies, and then evaluate the policies against a target set that includes instances, instance objects, databases, or database objects.
Policy and Rules for Database Engine
The following table lists the policies included in the set of sample policies and information about the best practices rules each policy evaluates. The policies are stored as XML files and must be imported into SQL Server. For more information about how to import policies, see Import a Policy-Based Management Policy.