How to Adjust SQLAgent % Processor Time Alerts
After adjusting the SQLAgent %Process Threshold value to "greater than 50"
(in Rule Groups>Microsoft SQL Server>Performance Rules>%Process Threshold),
alerts are still generated at values less than 50. For example, this alert:
---
Severity: Error
Status: New
Source: Process: % Processor Time: sqlagent
Name: %Processor
Description: Process: % Processor Time: sqlagent value = 36.1424122181892
---
So, I figure I am either adjusting the wrong rule or the adjustment has not
propogated to the agent yet (it's been over a week since adjusting and the
heartbeat is current).
Environment: Microsoft Management Console 2.0 (v. 5.2); running SQL Server
2005 and 2000 Management Packs; target agent is the MOM server using SQL
Server 2000 and Windows 2003 Standard Ed. (no service packs).
Anyone know what I'm doing wrong?
Thanks,
David
|