Top 100 queries

SQL Server performance monitoring and alerting

Moderators: Colin Millerchip, priyasinha, Adam, chriskelly

Top 100 queries

Postby uflores » Thu Aug 14, 2014 11:34 pm

Is there any way to list the top 100 queries?
uflores
 
Posts: 1
Joined: Thu Aug 14, 2014 11:33 pm

Postby stanori » Mon Aug 18, 2014 3:29 pm

Hello,

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
stanori
 
Posts: 84
Joined: Mon Apr 23, 2012 1:13 pm


Return to SQL Monitor 4

Who is online

Users browsing this forum: No registered users and 0 guests