Today I was going through one of my production SQL Servers and looking at the connectionsspids 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 – … Continue reading The Different States Of Worker Threads