sleeping (awaiting command) process blocking others

[vadimg]

Hi Gurus!!

SQL Server 2000
Windows 2000 Advanced Server

Can a process whose status is 'sleeping' and command is 'awaiting command' be blocking other processes?

well... i know it can, i just don't know why... Any help is greatly appreciated!!!!!!!!

sp_who2 output (only relevant columns):

spid status blkby command last_batch
97 sleeping . AWAITING COMMAND 02/25 17:31:00
135 sleeping 97 SELECT 02/25 17:31:00

 

[LFCfan]

possibly the transaction for spid 97 has not committed or rolled back, and it still holds a lock on a table that spid 135 is trying to access?
it's usually the culprit when i get that sort of thing!

hope this helps
Maria

 

[vadimg]

Maria, thanks for the advice...
You're right: if spid 97 is not committed/rolled back it will hold the locks, and sp_who2 will show it as a 'sleeping' process that is 'AWAITING COMMAND'.

But if the transaction executed by 97 IS commited. Is it possible for 97 to still hold on to any resources?

Thanks!