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?
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 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 17 SQL Server - Hanging Process - SPID Query 8 Can't Kill SPID "Transaction Rollback in Progress" 2 Negative SPID in SQL Server? 47 How to find out why the status of a spid is suspended? What resources the spid is waiting for? 4 Process running on sql server 2008 R2 with spid = -2 2 SQL Server Service Stuck in ‘Starting’ Status 5 Process/SPID is being blocked by itself, how to clear/kill without restarting Sql Server Load 7 more related questions Show fewer related questions
Reset to default
