Red Gate forums :: View topic - Long running query...query
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Response 1
SQL Response 1 forum

Long running query...query

Search in SQL Response 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
TedMaulUK



Joined: 08 Jul 2010
Posts: 1

PostPosted: Thu Jul 08, 2010 9:21 am    Post subject: Long running query...query Reply with quote

Hi,

I've had a quick search and haven't found an answer so apols. if there's one out there...

I have a query regarding the Long Running Query alert, in particular the 'Was running for:' value.

I have left the 'Query running for longer than' at the default 10s so I would expect the alert to to be raised shortly after the 10s threshold has been reached for any given query.

Instead, for all instances of this alert on the server I'm monitoring ithe 'Was running for' is always circa 45s

Why isn't the alert triggered at, say, 11 seconds? I've increased the 'Query running for longer than' to 30s and, as I would expect, am seeing the same results.

Is the alert only triggered once the query has finished executing or is there something else that determines it?

Thanks in advance

Ted
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1119
Location: My desk.

PostPosted: Fri Jul 09, 2010 3:34 pm    Post subject: Reply with quote

Hi,

The alert won't occur immediately after the time set - all that controls is how long the query must be running before it generates an alert.

The actual polling frequency is configured via an XML file (if you do want to change it - bearing in mind more frequent polling may affect server performance).

If you look for "config.xml" (mine is in C:\Program Files (x86)\Red Gate\SQL Response 1\Alert Repository) you'll see a line containing:

- <!-- This will affect the polling frequency for these alerts; Long running query and Blocked SQL Process - setting to every 45 seconds
-->
<SysProcessesTime>45</SysProcessesTime>

This means that the check will be made every 45 seconds; which is why the alert occurs in the way you see. i.e. the query lasted longer than 10 seconds so will trigger the alert, and was still going after 45 seconds, so you get that in the alert detail.

Hope that helps.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group