Designing Policy Based Management in Microsoft SQL Server 2008

  • 2/18/2009

Lesson 1: Designing Policies

SQL Server 2008 has a new feature called Policy Based Management, also known as the declarative management framework (DMF), to tackle the problem of standardizing your SQL Server instances. Although Policy Based Management can be used just to alert an administrator when an object is out of compliance, depending upon the type of policy, you can also enforce compliance by preventing changes that would violate a policy.

Policy Based Management introduces the following new objects that are used to design and check for compliance:

  • Facets

  • Conditions

  • Policies

  • Policy targets

  • Policy categories