February 9, 2011 at 3:22 am
Hi all
If a process is in the Runnable queue is this actually eating up resources in terms of CPU and IO? I have a process that has high CPU and IO numbers however it makes sense to me that these would only increase when running and not being in the runnable queue.
I am seeing high CPU usage on my server and so far this is the only process I could see is causing an issue.
Thanks
February 9, 2011 at 3:31 am
Good question. Please refer to final explanation in below link.
http://www.sqlnewsgroups.net/sqlserver/t12969-what-does-runnable-mean-sql-server.aspx
Hope this answers your question
M&M
February 9, 2011 at 6:05 am
How are you monitoring the process? If you use sys.dm_exec_requests you can see what the process is waiting on (as well as if other processes are waiting on it). If you're not comfortable with messing with the dynamic management objects, you might take a look at Adam Machanic's Who Is Active.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 9, 2011 at 6:38 am
Ok great thanks Grant I will check it out - btw I read your book on Execution Plans very informative 🙂
February 9, 2011 at 6:43 am
Kwisatz78 (2/9/2011)
Ok great thanks Grant I will check it out - btw I read your book on Execution Plans very informative 🙂
Thank you! It's good to know it's been helpful.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply