O'Reilly logo

Microsoft SQL Server 2012 Bible by Aaron Nelson, Jose Chinchilla, Patrick LeBlanc, Jorge Segarra, Adam Jorgensen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required