Delivering Manageability and Performance - SQL Server 2012 Internals and Troubleshooting - page 459

Once the condition has been created, create a new policy and select the check condition created
earlier. In the Against targets pane, choose Every Stored Procedure in Every database. If desirable,
change the Evaluation Mode to On change: prevent. This will cause an error and rollback for any
CREATE PROCEDURE statement that does not comply with the naming convention. Figure 16-9 shows
the policy coni guration.
FIGURE 16-9
Clustered Indexes
This is a potentially contentious topic, although many DBAs and some organizations mandate that
every table must have a clustered index. The following steps describe how to create the condition
and policy for reporting through PBM.
First, create a new condition, specify a meaningful name, and choose the facet named Table. Select
the i eld @HasClusteredIndex, use the equals operator, and choose the value True.
Next, create a policy and select every table in every database for the targets. The facet used in this
condition does not support enforcing the condition, so the Evaluation mode options are On Demand
or On Schedule. Figure 16-10 shows the policy coni guration.