What is blocking and how would you troubleshoot it?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
Is it possible to delete duplicate rows in a table without using a temporary table ?
how many layers of tcp/ip protocol combined of? : Sql server database administration
Explain about the command-line tool SQLCMD?
What is the difference between getdate and sysdatetime?
What is self contained sub query?
How do you open a cluster administrator?
What is auditing in sql server?
Why we need sql server?
how to connect sybase to sql server 2005?.
What is the maximum number of index per table?
Tell me the phases a transaction has to undergo?
Why use stored procedures in sql server?