MS SQL: long running queries

select spid,cmd,status,loginame,open_tran,
datediff (s,last_batch,getdate()) as [Waittime (s)]
from master..sysprocesses p
where open_tran > 0
and spid > 50
and datediff (s,last_batch,getdate()) > 30
and exists ( select * from master..syslockinfo
where req_spid=p.spid and rsc_type <>2)

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.