What is blocking and how would you troubleshoot

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What is blocking and how would you troubleshoot it?

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.

(Continued on next question...)

Other Job Interview Questions

• What are user defined datatypes and when you should go for them?
• What is the system function to get the current user’s user id?
• What is a self join? Explain it with an example.
• What are the steps you will take to improve performance of a poor performing query?
• How to determine the service pack currently installed on SQL Server?
• What is a deadlock and what is a live lock? How will you go about resolving deadlocks?
• When you create a database how is it stored?
• Do you know how to configure DB2 side of the application?
• What's SQL Server
• What is the difference between them (Ethernet networks and token ring networks)?
• More...