Processor utilization: seconds

SQL Server performance monitoring and alerting

Moderators: eddie davis, priyasinha, Adam, chriskelly, Chris Lambrou, Chris Spencer

Processor utilization: seconds

Postby fruyven » Tue Dec 06, 2011 3:17 pm

Hi,

In the alert setting for this alert I am able to set "For longer than n seconds".

However, in the actual raised alert I can't find the amount of seconds the alert was active (like shown in "Long running query"). Would be nice in order to determine a baseline.

More generally: maybe add seconds to "Time raised" and "Time ended" in the top line of the alert?

Thanks!
fruyven
 
Posts: 6
Joined: Tue Aug 23, 2011 11:01 am

Postby Chris Spencer » Wed Dec 07, 2011 12:59 pm

Hi

I've raised an enhancement request (ref: SRP-5513) for this.

For an alert like 'Processor Utilization' the duration would only be appoximate as we collect this data every 15 seconds. So we'd have to display something like:

Duration: Between 60 - 75 seconds.

Regards
Chris
Chris Spencer
Test Engineer
Red Gate
Chris Spencer
 
Posts: 301
Joined: Tue Aug 29, 2006 9:09 am
Location: Red Gate - Cambridge

Postby fruyven » Wed Dec 07, 2011 1:03 pm

Hi,

Thank you!
fruyven
 
Posts: 6
Joined: Tue Aug 23, 2011 11:01 am


Return to SQL Monitor 2

Who is online

Users browsing this forum: No registered users and 0 guests