We help IT Professionals succeed at work.

SPID process blocking itself


I have multiple process blocking itself.  It is a simple select statement

Select Column1, Column2, Column3, Clolumn4, Column5
From MyTable (NOLOCK)
Where Column5 = 0 AND Column2 IS NOT NULL AND Column4 IS NOT NULL

We are running SQL 2005  (9.00.4262.00) SP3 Enterprise Edition (64-bit)

SPID      Status                                      HostName      BlkBy      DBName      Command
83      SUSPENDED                           MachineName        .      DBName      SELECT          
83      RUNNABLE                            MachineName        .      DBName      SELECT          
83      SUSPENDED                           MachineName      83      DBName      SELECT          
83      SUSPENDED                           MachineName      83      DBName      SELECT          
83      SUSPENDED                           MachineName      83      DBName      SELECT          

I know this is an issue on SQL 2000 SP4 before.
Comment
Watch Question

Faiga DiegelSr Database Engineer

Author

Commented:
Thanks for the inout but it was the OS and server issue. We disabled one of the application job.