Monitor and Enforce Best Practices by Using Policy-Based Management
Policy-Based Management allows you monitor best practices for the SQL Server Database Engine. SQL Server provides a set of policy files 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. You can 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.
Policy and Rules for Database Engine
The following table lists the policies that are included with the installation of SQL Server and includes information about the best practices rules that 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.