« Oracle: long running queries | Home | Oracle: password function »
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)
Topics: T-SQL | Submitter: checkthis
Comments
You must be logged in to post a comment.
