Options
Querying for long running queries on a specific database
Tenrosei
Posts: 2
Hello I have a single sql server with 20+ databases in it and when you are in alerts and select the main server you can see long running queries but if you select only a specific database you no longer see their long running queries. is there some way I can get the long running queries to show up under their database or is there a way to query all alerts for a specific database (considering its a field in the long running query details).
Comments
The Long-running query alert is a SQL Instance level alert, it does not show up at the database level because it is not applicable at that level in SQL Monitor. Sean was correct that there is not way to get the Long-running query alert to show up under the database.
We have responded to the support call that was raised on this with a possible solution, if anyone else has a similar requirement please get in touch with support@red-gate.com.
Kind regards,
Alex
Have you visited our Help Center?