532
Part V: Enterprise Data Management
Similarly, PBM abstracts the management intent, meaning the policies, from the procedural
implementation. As the DBA, you defi ne what the system should be and then let SQL Server
fi gure out how to achieve it. Policy checking can be automated, with the results logged,
and in some cases even actively stop an action from occurring.Defi ning Policies
Policies may be defi ned interactively in Management Studio, loaded in from XML, or defi ned
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 fl exible
failover polices you can confi gure 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
built from Conditions, which are built out of facets:
■ (^) 84 Facets: Defi ned only by Microsoft, are collections of properties that represent a
management dimension. For example, the Table facet has 34 specifi c properties that
can be checked about a table. Examples of common facets include logins, a server, a
linked server, or an index. Inside each facet are anywhere from a handful to dozens
of properties, which can be referred to by a condition. (For a full list of the facets,
see Table 20-1 later in this chapter.)
c20.indd 532c20.indd 532 7/30/2012 5:45:09 PM7/30/2012 5:45:09 PM
http://www.it-ebooks.info