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

SQL Server — Max Degree of Parallelism
The intention of this policy is to ensure that the sp_coni gure option for Max Degree of Parallelism
(MaxDoP) has been optimized (i.e., the current running value is nondefault) on any server with
more than four CPUs.
Implementing this policy as described requires two conditions and one policy. The i rst condition will
be used as a check condition to verify that the MaxDoP setting is correct. The second condition
will be used as a server restriction to ensure that the policy applies only to servers with more than
four CPUs. Finally, the policy will bring together the check condition and the restriction condition
and determine the evaluation mode.
Start by creating the check condition shown in Figure 16-6.
FIGURE 16-6
Next, create a new condition that will be used for the server restriction. Create a new condition
named Greater than 4 CPUs , using the facet Server. In the Expression pane, use @Processors , and
set the Operator and Value to >4 .
The i nal step is to create the policy. Use the name SQL Server — MaxDoP and choose the check
condition and server restriction conditions created earlier. The policy should look like what is shown
in Figure 16-7.