Comments
Sort by recent activity
Thank you for answer, Colin!
Yes, I am aware of the configuration option you specified, I've use it for some queries . But in order to use it more effectively (to exclude the queries which lead to long running alert every time they run), I wanted to search in the data repository the queries which appear more often.
Thanks [image] / comments
Thank you for answer, Colin!
Yes, I am aware of the configuration option you specified, I've use it for some queries . But in order to use it more effectively (to exclude the queries which lead to ...
The series from Simple Talk is great, especially for introducing the function for "decoding" the collection date. I also found a helpful piece of code here: http://www.red-gate.com/MessageBoard/vi ... 458c03f49d . Still, it doesn’t answer the question regarding query duration, which I was not able to find it in the data repository, despite all my efforts.
In one of my servers we are monitoring, there are a lot of long running query alerts (up to 2000 per day) and I would like to change the configuration (to exclude some of the stored procedures which are constantly long running and we cannot improve them). I was thinking to use COUNT, with group by on query text, but I cannot find the query text as a part of the alerts tables presented by Chris Lambrou in his series.
Also, I would like to be able to prioritize the analysis of these alerts depending on how long the query takes, this is why I need to find the query duration in the data repository (we have to do such a prioritization taking in consideration the number of alerts raised).
If you decide to keep this policy of not publishing the schema, I think you should consider to introduce in the UI more options to filter or sort alerts.
Thank you in advance for your help,
Larisa / comments
The series from Simple Talk is great, especially for introducing the function for "decoding" the collection date. I also found a helpful piece of code here: http://www.red-gate.com/MessageBoard/vi...