SQL Server performance monitoring and alerting
Is there any way to list the top 100 queries?
- Posts: 1
- Joined: Thu Aug 14, 2014 10:33 pm
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.
Red Gate Software Ltd.
- Posts: 84
- Joined: Mon Apr 23, 2012 12:13 pm
Return to SQL Monitor 4
Who is online
Users browsing this forum: No registered users and 0 guests