Tutorial: Evaluating Best Practices Using Policy-Based Management

Welcome to the Evaluating Best Practices by Using Policy-Based Management tutorial. This tutorial is intended for users who are familiar with SQL Server, but new to Policy-Based Management.

Policy-Based Management, together with the best practices policies that are included beginning with SQL Server 2008, replaces the SQL Server 2005 Best Practices Analyzer. The best practices policies are based on a predefined list of SQL Server recommendations and best practices that are used to determine whether there are potential issues in your database environment. You can use the best practices policies that are provided with Policy-Based Management to analyze an instance of SQL Server to determine whether the instance meets best practices guidelines and recommendations.

What You Will Learn

In this tutorial, you will learn how to evaluate best practices policies for the SQL Server Database Engine on an on-demand (or "ad hoc") basis, or on a scheduled basis.

This tutorial is divided into two lessons:


This lesson requires basic database knowledge and a basic understanding of SQL Server Management Studio.

To use this tutorial, the server must have Management Studio installed.


When you are reviewing tutorials, we recommend that you add Next and Previous buttons to the document viewer toolbar. For more information, see Adding Next and Previous Buttons to Help.