Skip to content

Latest commit

 

History

History
47 lines (37 loc) · 2.95 KB

File metadata and controls

47 lines (37 loc) · 2.95 KB
title Tutorial: Evaluating Best Practices by Using Policy-Based Management | Microsoft Docs
ms.custom
ms.date 06/13/2017
ms.prod sql-server-2014
ms.reviewer
ms.technology database-engine
ms.topic conceptual
helpviewer_keywords
best practices analyzer
Policy-Based Management, best practices policies
Best Practices [Database Engine]
Policy-Based Management, evaluating policies
BPA
tutorials [Policy-Based Management]
Policy-Based Management, tutorials
ms.assetid c7867f9b-7acc-4fae-bde1-63808c403ebc
author VanMSFT
ms.author vanto
manager craigg

Tutorial: Evaluating Best Practices by 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 [!INCLUDEssNoVersion], 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 [!INCLUDEssNoVersion] 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 [!INCLUDEssDEnoversion] 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 [!INCLUDEssNoVersion].

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 [!INCLUDEssNoVersion].

Requirements

This lesson requires basic database knowledge and a basic understanding of [!INCLUDEssManStudioFull].

To use this tutorial, the server must have [!INCLUDEssManStudio] installed.

Start the Tutorial

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

See Also

Administer Servers by Using Policy-Based Management