Loading

Sql Server Blocking Issue.

Vignesh Mani

9y1.1k

When run sql server simple query it is taking more time. I do not know that somthing blocking in sql server,. How do find it?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Manish Kumar9y ago
Use below query to find out which process id (spid) is blocked

select * from sys.sysprocesses where blocked<>0

and to find out what query is blocking sql server use below query.

select * from sys.dm_exec_sql_text (0x0100080046D0CE3A602752773B00000000000000)

Here yellow part is sql_handle column from sys.sysprocesses tables.

0
Subodh Natoo9y ago
SQL Server has inbuild query to check the status of currently running queries on the server.
Simply execute sp_who2 command to check which queries taking time to execute.
0