SQL Server Database Administrator Question:
Tell me what is blocking and how would you troubleshoot it?
Answer:
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.
| Previous Question | Next Question |
| What purpose does the model database serve? | Do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? |