Evaluate a Policy-Based Management Policy from That Policy

THIS TOPIC APPLIES TO: yesSQL ServernoAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

This topic describes how to evaluate a policy using that policy in SQL Server 2017 by using SQL Server Management Studio.

In This Topic

Before You Begin



Requires membership in the PolicyAdministratorRole role in the msdb database.

Using SQL Server Management Studio

To evaluate a policy

  1. In Object Explorer, click the plus sign to expand the server that contains the policy that you want to evaluate.

  2. Click the plus sign to expand the Management folder.

  3. Click the plus sign to expand Policy Management.

  4. Click the plus sign to expand the Policies folder.

  5. Right-click the policy that you want to evaluate and select Evaluate.

  6. In the Evaluate Results dialog box, you see the results of the policy evaluation. For targets that do not comply with the policy and have properties that can be reconfigured by Policy-Based Management, you can enforce compliance by clicking Apply. For more information on the available options in the Evaluate Policies dialog box, see Evaluate Policies Dialog Box, Policy Selection Page and Evaluate Policies Dialog Box, Evaluation Results Page.

  7. When finished, click Close.