Thursday, March 22, 2012

How to find blocking in SQL server and killing blocking process

Following command will give you detail of all the processes
sp_who2

You can find out all the process which have created blocking through following command
select cmd,* from sys.sysprocesses where blocked > 0

 You can kill the blocking process with the following command
kill 54

No comments:

Post a Comment