Defining Policies

Policies may be defined interactively in Management Studio, loaded in from XML, or defined with either T-SQL code or PowerShell with DMO.

What's New with PBM in SQL 2012
Policy-Based Management as a whole hasn't changed much since SQL Server 2008 R2, but there are 8 new facets available to you. The new facets for availability groups are the basis of the flexible failover polices you can configure for AlwaysOn Availability Groups, which you can read more about in Chapter 27 “Database Mirroring.” The following list calls out the new facets in SQL Server 2012 and what properties they contain.
  • Availability Database: Properties of databases in an availability group including their name, status and synchronization states
  • Availability Group: Availability Group properties, such as health check timeouts, failure condition level, and name of the replica holding the role of primary in the group
  • Availability Group State: State of the Availability Group
  • Availability Replica: Properties of the Availability Replica object including operational state, quorum vote count, connection state and much more
  • Search Property List: Properties of the Search Property Lists, used in Semantic Search
  • Sequence: Properties of sequence objects
  • Database Replica State: Properties of the physical database replicas participating in an availability group
  • Server Role: Properties of the server role object

There are three types of PBM objects. In a sense they function as three levels, with Policies ...

Get Microsoft SQL Server 2012 Bible now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.