How do you use cloud databases? Take the survey.

Emailing Top 50 Queries for a Database

I need to pull the worst performing queries and email it to my development team at least once a week. There's no good reporting option to do this so I was wondering if I can do this by pulling data directly out of the Redgate Database. Can this be done?
Tagged:

Answers

  • Hi @jstretto,

    Unfortunately, it's not possible to be able to pull this information directly out of the database. The Top 10/25/50 queries can only be viewed from the Overviews section in SQL Monitor, with their query plans as well.

    The query plans themselves can be queried, which is just done through the sys.dm_exec_query_plan table.

    Apologies for the inconvenience.

    Kind regards,

    Kurt McCormick
    Product Support Engineer, Redgate

    Need help? Take a look at our Help Center

Sign In or Register to comment.