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
This entry was posted on March 12, 2017 at 9:32 pm and is filed under Performance Tuning.
Tagged: cpu intensive queries, memory intensive queries, Performance reports, Performance Tuning, Slow running queries. 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