4 Replies Latest reply on Mar 24, 2019 12:36 PM by darichar

    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?