This topic has not yet been rated - Rate this topic

Tutorial: Evaluating Best Practices by Using Policy-Based Management

SQL Server 2012

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 is a system for defining policies that can be used enforce site administration standards. Policy-Based Management includes a set of best practices policies that you can use 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:

Lesson 1: Evaluate Best Practices on an On-Demand Basis: In this lesson, you perform an on-demand evaluation of the policies against one or more instances of SQL Server.
Lesson 2: Evaluate Best Practices Policies on a Scheduled Basis: In this lesson, you configure best practices policies to run on a scheduled basis. The lesson shows how to configure scheduled policies on a single instance, and how to deploy scheduled policies from a central location to multiple instances of SQL Server.

Requirements

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.

Start the Tutorial

Lesson 1: Evaluate Best Practices on an On-Demand Basis

Concepts

Administer Servers by Using Policy-Based Management

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD