|
The following custom counter can be encorperated into a Spotlignt on SQL Server Enterprise deployment to generate alarms whenever a SQL Server agent job runs longer than normal. The counter will return the number of jobs who'se previous execution was more than N times the jobs average duration. There are a few user configurable parameters in the collection script to fine tune the collection script.
|
