How do you find out blocking in sql ?

Find blocking in single database.

->Run sp_who2

->By running above sp,we can able to find out blockings by presence of blkby column value.

->Find the spid related to the  blkby value row.

->Find the sql statement responsible for blocking by

DBCC INPUTBUFFER(spid)

->if select statement pertaining to that spid means,kill that spid.

 KILL spid

->if insert,update,delete statement pertaining to that spid means,discuss with customer before killing the spid.


Comments

Popular posts from this blog

SSIS2008R2 Error: 0xC0209303 at Package:

SQL2008R2 Error: The remote copy of database "XXXXX" has not been rolled forward to a point in time that is encompassed in the local copy of the database log. (Microsoft SQL Server, Error: 1412)