Social Icons

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

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


Sample text

Sample Text