Microsoft SQL Server 2008 R2 Specifiche Scaricare il pdf (Pagina 55)

Managing Utility Administration Settings CHAPTER 2 35

FIGURE 2-6 Modifying global policies for managed instances

Volatile Resource Policy Evaluation

The nal section on the Policy tab is Volatile Resource Policy Evaluation. This section, dis-

played in Figure 2-7, provides strategies to minimize unnecessary reporting noise and un-

wanted violation reporting in the SQL Server Utility. You can choose how frequently the CPU

utilization policies can be in violation before reporting the CPU as overutilized. The default

evaluation period for processor overutilization is 1 hour; 6 hours, 12 hours, 1 day, and 1

week can also be selected. The default percentage of data points that must be in violation

before a CPU is reported as being overutilized is 20 percent. The options range from 0 per-

cent to 100 percent.

1 2 ... 50 51 52 53 54 55 56 57 58 59 60 ... 235 236

Nessun commento

Microsoft SQL Server 2008 R2 Specifiche Pagina 55