What is blocking and how would you troubleshoot it?

Question Posted / swapna

3 Answers
6656 Views
HCL, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is blocking and how would you troubleshoot it?..

Answer / swapna

Blocking happens when one connection from an application
holds a lock and a second connection requires a conflicting
lock type. This forces the second connection to wait,
blocked on the first.

Is This Answer Correct ?

4 Yes

0 No

What is blocking and how would you troubleshoot it?..

Answer / rajkumar

Blocking happens when one connection from an application
holds a lock and a second connection requires a conflicting
lock type. This forces the second connection to wait,
blocked on the first.

sp_who2 will give the list of blocking sessions. From that
we can find the objects using dbcc command.

Is This Answer Correct ?

3 Yes

0 No

What is blocking and how would you troubleshoot it?..

Answer / harikrishna

Blocks will occur when one processes holds a lock and
second processes requires a conflicting
lock type, then it blocks, check weather the I/O is moving
or not for the blocked processes.
use the below command to know the route block.
select spid,blocked from sysprocesses where blocked>0

Is This Answer Correct ?

2 Yes

0 No

Post New Answer