sql worker threads

I just need to understands what worker threads mean in sql server, Our sql logs prompt us with this error in the sql logs, is this something related with number of worker thread which we set in sp_configure ?


Stack Signature for the dump is 0x00000000      
Error: 17884, Severity: 1, State: 0              
Potential deadlocks exist on all the schedulers.
Error: 17884, Severity: 1, State: 0              
Potential deadlocks exist on all the schedulers.
Error: 17884, Severity: 1, State: 0              
Potential deadlocks exist on all the schedulers.
motioneyeAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
QPRConnect With a Mentor Commented:
"The worker thread represents a logical thread in SQL Server that is internally mapped (1:1) to either a Windows thread or, if lightweight pooling is turned ON, to a fiber. The mapping is maintained until the worker thread is deallocated either because of memory pressure, or if it has been idle for a long time. The association of a task to a worker thread is maintained for the life of the task"
http://msdn.microsoft.com/en-us/library/ms189267.aspx


However, regarding the error you have posted:
http://technet.microsoft.com/library/Cc917684

Not light reading but deasl with what you are experiencing
0
 
jogosCommented:
Which sql version?
0
 
Peter KipropConnect With a Mentor Commented:
Hi motioneye,

I would put simply this way

it is the number of simultaneously executing commands that SQL server can accommodate at any given time. It is normally dependent on the number of available CPUs.

By default, the max worker threads setting is 0 in SQL Server 2005 and in SQL Server 2008. The default maximum is 255.
0
 
SJCFL-AdminConnect With a Mentor Commented:
If you want a generic analysis, it could be a time of high concurrent activity or a poorly optimized system where the transactions are not processing through the system quickly enough for the volume in general.  I'd turn on the activity monitor and check the waits to see where areas of improvements could be made.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.