Link to home
Start Free TrialLog in
Avatar of Faiga Diegel
Faiga DiegelFlag for United States of America

asked on

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.
ASKER CERTIFIED SOLUTION
Avatar of avirups
avirups
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Faiga Diegel

ASKER

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