Users: 30k; Pages Per Session: 2.5p; Avg. Session Duration: 1:35mi
Explore Tools
{Featuring Microsoft Technologies + Enterprise Data + Cloud Computing}

SQL Server PBM - Policy, Condition, Facet
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)

Policy-Based Management(PBM) is a system for managing SQL Server systems. The hierarchy is Policy:Condition:Facet. Basically you create a Condition, which is comprised of a Facet with an Expression(Field, Operator, Value) for it. Next, you create a Policy which is comprised of a Condition, Target & Evaluation Mode. One use case is, as the DBA, you may have a requirement that specific SQL Server's have Mixed Mode Authentication configured, so you create a Condition and a Policy that Gets or Enforces that Server Option. Effectively allowing you to check whether an instance of SQL Server is in compliance with the Policy or enforce a Policy.

A Facet is a collection of properties that describe some functionality of SQL Server related to an area of Management. Some common Facets are Database, Login & Server Security.

List of SQL Server Facets:

Example - Create a Policy to check the Server Security Login Mode:

Create a New Condition:

Create a New Policy:

Evaluate the Policy:

That's it !

Policy-Based Management is a great system for defining, implementing, reporting & enforcing standard management policies for an organization SQL Server Environment(s).