Specifications

36 CHAPTER 2 Multi-Server Administration
FIGURE 2-7 Volatile resource policy evaluation
The next set of congurable elements allows you to determine how frequently CPU utiliza-
tion polices should be in violation before the CPU is reported as being underutilized. The de-
fault evaluation period for processor underutilization is 1 week. Options range from 1 day to 1
month. The default percentage of data points that must be in violation before a CPU is reported
as being underutilized is 90 percent. You can choose between 0 percent and 100 percent.
To change policies, use the slider controls to the right of the policy descriptions, and then
click Apply. You can also restore default values or discard changes by clicking the buttons at
the bottom of the display pane.
REAL WORLD
L
et’s say you congure the CPU overutilization polices by setting the Evaluate SQL
Server Utility Polices Over This Moving Time Window setting to 12 hours and the
Percent Of SQL Server Utility Polices In Violation During The Time Window Before
CPU Is Reported As Overutilized setting to 30 percent. Over 12 hours, there will
be 48 policy evaluations . Fourteen of these must be in violation before the CPU is
marked as overutilized.