Red Gate forums :: View topic - How to tell which queries are causing high CPU
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Monitor 3
SQL Monitor 3 forum

How to tell which queries are causing high CPU

Search in SQL Monitor 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
lrobbins



Joined: 03 Jan 2013
Posts: 5
Location: United States

PostPosted: Mon Jan 06, 2014 9:14 pm    Post subject: How to tell which queries are causing high CPU Reply with quote

Is there a way in RedGate monitor to tell which queries are causing high CPU on a SQL server?
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6670

PostPosted: Wed Jan 08, 2014 11:38 am    Post subject: Reply with quote

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 * 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.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group