What is blocking and how would you troubleshoot it?
Answer Posted / 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 |
Post New Answer View All Answers
Can you explain the disadvantages/limitation of the cursor?
What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?
What is a natural primary key?
explain databases and sql server databases architecture? : Sql server database administration
what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration
How to insert multiple rows with a subquery?
Different types of keys in SQL?
What are different types of join?
What is difference between equi join and inner join?
What is sleeping status in sql server?
What to check if a User database is locked?
What is Lock table in SQL?
What are sql servers used for?
How to list all schemas in a database?
How to copy data from one table to another table?