How to tell which queries are causing high CPU

Monitor, diagnose and receive alerts to problems across your SQL Servers.

How to tell which queries are causing high CPU

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

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

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


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: 6590
Joined: Mon Aug 23, 2004 9:48 am

Return to SQL Monitor Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests