Queries Contributing to CPU Usage

In DPA, I can see that my SQL Server's CPU utilization is riding about 25% during business hours.

What is the easiest way for me to see which queries are using the most CPU? e.g. "This stored procedure is contributing to about 10% (2.5% overall) of the CPU usage."

This seems to me to be different than monitoring wait stats - but maybe that is my misunderstanding, and if so, which waits would be the most appropriate for this scenario?

Find more posts tagged with

cpu monitoring

sql server cpu

Accepted answers

All comments

darichar

Even though it's not an exact measurement of CPU, the Memory/CPU wait is a great proxy for what you are looking for. If you tune the queries waiting on this, you should reduce the overall CPU usage on the database server.

A great way to see the Top queries waiting on Memory/CPU is to use a report named "Top SQLs for a single Wait" and choose the Memory/CPU wait.

mheydman

Thank you for the response- I will give that a go!

houshyar

Dear Darichar

where can i find "Top SQLs for a single Wait" report?

darichar

Under the Reports link, it is an option for reporting: