Top 100 queries
uflores
Posts: 2
Is there any way to list the top 100 queries?
Comments
Thanks for your forum post. Within SQL Monitor we have the ability to show you the top 10 queries. See this article below for more details:
https://documentation.red-gate.com/disp ... iagnostics
We currently do not have the ability to display more than 10 in our most recent version. However, if you would like to pull this from SQL Server, here is an article that contains a sample query that you could modify to help you pull the top 100 queries:(example gives Top 10)
http://serverfault.com/questions/162245 ... sql-server
Hope this helps.
Best Regards,
Steve
Steve Tanori
Product Support
Red Gate Software Ltd.
866-997-0378