The OS Processor Time (Percent) alert provides the percentage of CPU time used by all processes on the computer hosting your SQL Server instance. The WMI object Win32_PerfRawData_PerfOS_Processor
property PercentProcessorTime
is measured to get percent processor time.
If this value regularly exceeds 75%, you should take action such as:
SELECT * FROM Northwind.dbo Employees
is a fully-qualified object reference whereas SELECT * FROM
Employees
is a poorly-qualified object. You can reuse the execution plans of fully-qualified objects "as is," whereas plans where you either cannot reuse the not fully-qualified objects or, if they are reused, then they are subject to a highly restrictive COMPILE
lock while SQL Server determines if all of the objects referenced in the T-SQL code have the same owners as the execution plan currently in cache. Both of these situations consume a significant amount of CPU time.SQL Diagnostic Manager is unable to collect the corresponding counter due to one of the following reasons:
To enable alerting when this metric is outside its established baseline, click the Baseline Thresholds Enabled (as percentage of baseline) check box in the Alert Configuration window. |
| | | | | | | |