Data World

SQL Server Tuning: Find Slow running queries using the Reports in SSMS

Posted by Pramod Singla on March 12, 2017


Find Slow running queries using the Reports in SSMS

1) High CPU consuming Queries: To run the report right click the server name in SSMS>reports>standard Reports>performance –Top queries by average Time

Figure 1: How to get to the performance reports

Figure 2:  Top 10 queries by CPU time

2) Queries with highest IO: To run the report right click the server name in SSMS>reports>standard Reports>performance –Top queries by average IO


Figure 3: Top 10 quries by IO

3) Server Dashboard: To run the report right click the server name in SSMS>reports>standard Reports>Server Dashboard


Figure 4: Server Dashboard

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: