New training: Streamlining alerts in SQL Monitor. Watch now.

How can I see alerts for a given database?

slimshakyslimshaky Posts: 13 New member
On the alerts tab, I can drill down to a server, then an instance, and then a database. However, it seems that most of my alerts do not appear when I click on a particular database. For example, I may have many long running queries that ran against a given database, but these alerts only display when I select the instance and not when I select the database. Is there a good way to see all of the alerts for that database? We are running SQL Monitor 9.
Tagged:

Answers

  • Hi @slimshaky,

    The problem you're describing is because long-running query alerts are instance level alerts rather than database level alerts.  For normal SQL instance / database the Long-Running Query and anything else that is an instance level (or higher) alert doesn't show up at the database level.

    You can see what alerts will be able to be shown at each level in the Configuration > Alert settings by clicking onto the database level it will only show you the alerts you can customize at that level and these are the only alerts that will show up when you drill down to that level:


    The Azure SQL Databases are different in this regard.

    I hope that helps!

    Kind regards,
    Alex
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
  • slimshakyslimshaky Posts: 13 New member
    Thanks for the explanation. If I want to get a list of long running queries specific to a database, is that something that I can query against on the back end?
  • Hi @slimshaky,

    We do not support the direct querying of the data repository but there are some queries around that may help. 

    This one https://redgatesupport.zendesk.com/hc/en-us/articles/360009784854 goes over how to see the compressed query text column, and the sample query looks like it associates that with a database so it may work for you.

    Kind regards,
    Alex
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
Sign In or Register to comment.