Home Article SQL Server Script to Check Blocking 
Script to Check Blocking PDF Print E-mail
User Rating: / 0
PoorBest 
SQL Server - Articles
Written by Sarabpreet Singh   

This query will show you all user processes in sql server (all versions) which are blocked.

 

 

select loginame,spid,* from master..sysprocesses where blocked<>0 order by waittime desc

Comments
RSS
Only registered users can write comments!

3.26 Copyright (C) 2008 Compojoom.com / Copyright (C) 2007 Alain Georgette / Copyright (C) 2006 Frantisek Hliva. All rights reserved."

 

Statistics

Content View Hits : 63184

Powered by Solutions-Guru.com!. Designed by: budget hosting reseller hosting packages Valid XHTML and CSS.