Script for
monitor blocking in prod server .
select
loginame,cpu,memusage,physical_io,* from master..sysprocesses a where exists (
select b.* from master..sysprocesses b where b.blocked > 0 and b.blocked =
a.spid ) and not exists ( select b.* from master..sysprocesses b where
b.blocked > 0 and b.spid = a.spid )order by spid
No comments:
Post a Comment