October 1, 2010 at 7:13 am
Hi All,
This is something I've never seen before so I was hoping to see if maybe one of you may be familiar with the cause of this exception in SQL Server 2008 R2.
/**********************************************
The query processor could not start the necessary thread resources for parallel query execution.
**********************************************/
Is there one particular wait type I should investigate further to help me find this answer. Again, this is the first time I've seen this type of exeption in our environment.
Thanks for the help!
😀
October 1, 2010 at 7:20 am
Sorry guys, I just noticed that my topic heading has "Count" instead of "Could", which is confusing.
My apologies...
😀
October 1, 2010 at 8:18 am
That's basically a hardware issue and means that your processors are maxed out. In terms of waits to monitor for a situation like this? CXPACKET & SOS_SCHEDULER_YIELD are indications of CPU pressure. CXPACKET can be caused by parallelism issues. Also just look at stuff like context switching & processor queue length.
"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
October 1, 2010 at 8:37 am
Thanks Grant!
We were fortunate that our Senior DBA was monitoring this server during the time frame of that exception. He was not seeing any CPU pressure during this time frame, so this is puzzling us at the moment.
We use a variety of "Activity Monitor" and "Quest Spotlight" to capture our real time performance data.
😀
October 1, 2010 at 8:48 am
Tim Parker (10/1/2010)
Thanks Grant!We were fortunate that our Senior DBA was monitoring this server during the time frame of that exception. He was not seeing any CPU pressure during this time frame, so this is puzzling us at the moment.
We use a variety of "Activity Monitor" and "Quest Spotlight" to capture our real time performance data.
Oh, well, it's probably Spotlight then. That thing is a pig.
"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 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply