Visite Webhosting Latino, el site sobre alojamiento web.
How to Adjust SQLAgent % Processor Time Alerts - Mombu the Microsoft Forum
Mombu the Microsoft Forum sponsored links

Go Back   Mombu the Microsoft Forum > Microsoft > How to Adjust SQLAgent % Processor Time Alerts
User Name
REGISTER NOW! Mark Forums Read

sponsored links

1 24th February 04:15
External User
Posts: 1
Default 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?


  Reply With Quote

  sponsored links


Thread Tools
Display Modes

Copyright 2006 - Dies Mies Jeschet Boenedoesef Douvema Enitemaus -