[Req]: Job Duration Unusual - add time floor

Monitor, diagnose and receive alerts to problems across your SQL Servers.

Moderators: eddie davis, david connell, dlkj, Colin Millerchip, priyasinha, Emma A

[Req]: Job Duration Unusual - add time floor

Postby bdill » Wed Mar 17, 2010 8:44 pm

For the "Job Duration Unusual" alert, please add an additional parameter.

Deviates from baseline by more than [ ] %
and ran for at least [ ] seconds.

Similar to the CPU utilization unusual.

For a really short running job, a change of just a few seconds could be a huge deviation %, but it doesn't concern me unless it runs for more than xxx seconds.

Another option (better in my opinion) would be:

Deviates from baseline by more than [ ] %
or by [ ] seconds - whichever is greater
Posts: 28
Joined: Tue Feb 15, 2005 10:02 pm
Location: Nashville, TN

Postby priyasinha » Thu Mar 18, 2010 10:36 am

Thanks a lot for your feedback. I have included this in our feature list. For your reference, the tracking id is SSR-1661.

Posts: 532
Joined: Wed Jan 03, 2007 5:02 pm

Return to SQL Response 1

Who is online

Users browsing this forum: No registered users and 0 guests