Activity overview
Latest activity by Ian Gill
Thanks Priya
I see you repeated the answer that was already on this thread [image]
Anyway, I do now understand the position. Providing an option to "configure" these "long running query" alerts is very misleading. I think that when you try to configure the alert you should be warned that unless the .xml file is changed then the minimum query length to trigger an alert is 45 seconds.
Also, for any other novices (like me) reading this thread, note that you have to stop the SQL Alert Service and restart it for the changes to the .xml file to take effect.
Ian / comments
Thanks Priya
I see you repeated the answer that was already on this thread
Anyway, I do now understand the position. Providing an option to "configure" these "long running query" alerts is very ...
Hi
I have the same question as chambem9.
I have read Anu's reply but it doesn't seem to answer the question. Anu's answer explains why an e-mail alert will only be sent for the first alert, but it does not explain why the alert itself is not created.
I have the alert setting at 10 seconds. I run a query that takes 15 seconds. No alert is created. I have not configured the e-mail notification and that is not a problem for me - I am just looking at the alerts generated in SQL Response.
I have also read the following thread. http://www.red-gate.com/MessageBoard/vi ... ning+query
This explains how often the system checks for long running queries, but it doesn't explain why a query that runs for longer than 10 seconds does not generate a query.
I do get some alerts for long running queries, but these all related to queries running for at least 45 seconds.
What am I doing wrong, i.e how do I ensure that I get an alert for any query that runs for more than 10 seconds?
Ian / comments
Hi
I have the same question as chambem9.
I have read Anu's reply but it doesn't seem to answer the question. Anu's answer explains why an e-mail alert will only be sent for the first alert, but it...