Emailing Top 50 Queries for a Database

jstretto

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?

Kurt_M

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.