Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQLAgent - Alert Engine Expand / Collapse
Author
Message
Posted Tuesday, May 5, 2009 11:55 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 5:56 AM
Points: 1,068, Visits: 3,033
SQLAgent - Alert Engine using more CPU usage.

1. how to check and resetting sampling interval under SQL Server registry?

for PerformanceSamplingInterval in MSSQLServer\SQLServerAgent which sets the sampling interval.

2. I road some artical, they suggested we can delete Demo: Alert under sql server agent. If i deleted for all demo alerts then waht will happend? how sql server agent working with sp_sqlagent_get_perf_counters?

thanks
Post #710830
Posted Wednesday, May 6, 2009 12:53 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 5:56 AM
Points: 1,068, Visits: 3,033
I had reset values PerformanceSamplingInterval 30 insted of 14. under

MSSQLServer\SQLServerAgent\PerformanceSamplingInterval.

I thought it will reduced the more cpu usage.

Post #710847
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse