Home Forums SQL Server 7,2000 Administration task manager background process blocking RE: task manager background process blocking
mromm
SSCarpal Tunnel
Points: 4301
More actions
December 20, 2002 at 10:46 am
#444934
Try to run
sp_who2 Active
instead of just sp_who2. It will show you what processes are actually doing something, not idle. Also, can you see what process ID is blocking your process? It is in the column BlkBy (Blocked By).
Michael