The Different States Of Worker Threads
- 0
- Add a Comment
Today I was going through one of my production SQL Servers and looking at the connections\spids it dawned on me that some people that are new to SQL Server might not know the different “states” of a worker thread. Here are 3 states that you will come across when executing sp_who or sp_who2:
Running - The worker is currently executing on the CPU
Runnable - The worker is currently waiting for its turn on the CPU
Suspended - The worker is waiting on a resource, for example, a lock or an I/O
These states are good to know in case you need to troubleshoot your system for bottlenecks.