How to tell which queries are causing high CPU

SQL Server performance monitoring and alerting

Moderators: eddie davis, priyasinha, Adam, chriskelly, Chris Lambrou, Chris Spencer

How to tell which queries are causing high CPU

Postby lrobbins » Mon Jan 06, 2014 9:14 pm

Is there a way in RedGate monitor to tell which queries are causing high CPU on a SQL server?
lrobbins
 
Posts: 5
Joined: Thu Jan 03, 2013 10:31 pm
Location: United States

Postby Brian Donahue » Wed Jan 08, 2014 11:38 am

Hello,

CPU usage corresponds more to SQL Server system processes, so if you first get a list of processes, you can check the CPU cycles they use and then hopefully you can work out which queries correspond to which processes.

Running this query against the master database should show the CPU:
Code: Select all
SELECT * FROM sysprocesses


If you just want to see if the query is optimal, you can use the SQL Server Profiler (that comes with SQL Server's management tools) and run the query through the execution plan wizard and that should tell you if you can improve the query.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Monitor 3

Who is online

Users browsing this forum: No registered users and 0 guests