Long running query per query
amollentze
Posts: 6
Would it be possible to break down the long running query into the different queries reported, and let the user include or exclude queries and modify settings per query? (Similar to the way that jobs are reported)
The reason for this is that the nature of certain queries are that they will run longer than e.g. 10 seconds and you only want to be informed when this extends beyond 30 seconds. Other queries might be optimised but will still run longer than the set 10 seconds, but you no longer want to receive notifications about them. This way you can only focus on the problem areas.
I hope I've made myself clear...
Anna-Mari
The reason for this is that the nature of certain queries are that they will run longer than e.g. 10 seconds and you only want to be informed when this extends beyond 30 seconds. Other queries might be optimised but will still run longer than the set 10 seconds, but you no longer want to receive notifications about them. This way you can only focus on the problem areas.
I hope I've made myself clear...
Anna-Mari
Comments
It keeps detecting a "send email" query that often takes more than 10 seconds... but no other queries should. So it would be good to to have that particular query NOT generate the alert.
Any support for that?
This is not supported in SQL Response Version 1. But we are right now working on SQL Response Version 2 and this feature is under strong consideration for V 2.0. For your reference, the enhancement number for this request is SSR-1336.
Regards,
Priya
Project Manager
Red Gate Software