Sql Server Spid Stuck on Runnable with Nothing Blocking

Elena Rostova
Elena Rostova
• • 2 min read

I Have a Sql Server Spid That Is Running a Query with a Status of "Runnable". I Can See the Cputime and Diskio Slowly Increasing over Time. There Are No Blocks...

Sql Server Spid Stuck on Runnable with Nothing Blocking

I have a SQL Server SPID that is running a query with a status of "runnable". I can see the CPUTime and DiskIO slowly increasing over time. There are no blocks and no waits when using sp_who2 and sp_whoisactive. The query usually takes 5 minutes to complete but is taking what seems like forever. Any ideas on why this is taking so long?

3
Related questions
11
SQL Server - Why would my SPID be "SUSPENDED" but not blocked, while creating an index?
2
SQL Server 2005 Sleeping SPID blocking another SPID
2
SQL SPID Blocking itself
Load 7 more related questions Show fewer related questions

Must Read

Elena Rostova

Elena Rostova

Lead Health, Wellness & Medical Journalist
Instagram Linkedin Twitter

Elena Rostova holds a Master's degree in Public Health Journalism. She covers groundbreaking medical research, holistic wellness trends, mental health awareness, and nutritional science.

Share this article