Export (0) Print
Expand All

Lesson 2: Evaluate Best Practices Policies on a Scheduled Basis


Applies To: SQL Server 2016

You can configure scheduled evaluations of best practices policies on one or more instances of SQL Server. To configure best practices policies to run on a scheduled basis, you must import the policies into the target instance.

To deploy scheduled policies to multiple servers, you can import the policies to one instance, configure the schedules for each policy, export the scheduled policies to a folder, and then deploy the scheduled policies to target instances through Registered Servers.

System_CAPS_ICON_important.jpg Important

The target instances must be running SQL Server 2008 or a later version. Automation requires the policies to be stored locally on the instance, which is not supported by versions of SQL Server that are earlier than SQL Server 2008.

In this lesson, you will do the following:

  • Import the best practices policies into an instance of SQL Server.

  • Configure the policies to run on a schedule.

  • Deploy the scheduled best practices policies to multiple instances through Registered Servers.

This lesson contains the following topics:

Administer Multiple Servers Using Central Management Servers

Community Additions

© 2016 Microsoft