12 2013 档案

使用语句查询mssql死锁
摘要：select spid, blocked, loginame, last_batch, status, cmd, hostname, program_name from sys.sysprocesses where spid in( select blocked from sys.sysprocesses where blocked 0 ) or (blocked 0)存着，时不时都要用来查查 阅读全文
posted @ 2013-12-25 17:19 生命体验之kevin-Y 阅读(1490) 评论(0) 推荐(0)