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

This entry was posted on March 12, 2017 at 9:32 pm and is filed under DBA, Performance Tuning. Tagged: , , , , . You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply

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

Gravatar
WordPress.com Logo

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

Google+ photo

You are commenting using your Google+ 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 )

w
Cancel

Connecting to %s

«
»