How to find SQL Server Locks,Blocked Processes?

Hello Sandeep,

You can use below query for finding the blocked process in SQL.

USE Master GO SELECT * FROM sys.dm_exec_requests WHERE blocking_session_id <> 0; GO

For more information, you can go to the below link

https://www.mssqltips.com/sqlservertip/2429/how-to-identify-blocking-in-sql-server/

0

Try below query for finding blocking of a particuler spid (server process id or session id).

select * from sys.sysprocesses where blocked<>0

If you find any row, then pick the sql_handle column value and try in below query

select * from sys.dm_exec_sql_text (0x03000800AD4A4F486957F00058A6000001000000)

This will show query why sql server is blocking

0

Hello

Below is best article to understand this scenario :

https://blog.wsol.com/sql-server-locks-blocked-processes-and-two-easy-ways-to-find-them

https://www.mssqltips.com/sqlservertip/2429/how-to-identify-blocking-in-sql-server/

Thanks

0