MS SQL - Locking

SQL Server, Lock Objects (On Performance Counter)
http://msdn.microsoft.com/en-us/library/ms190216.aspx?wa=wsignin1.0


Locking in Database Engine (SQL Server 2008 R2)
http://msdn.microsoft.com/en-us/library/ms190615.aspx


Locking
http://msdn.microsoft.com/en-us/library/aa213037(SQL.80).aspx

Concurrency Problems

http://msdn.microsoft.com/en-us/library/aa213029(SQL.80).aspx

• Lost or buried updates.
  
• Uncommitted dependency (dirty read).
  
• Inconsistent analysis (nonrepeatable read).
  
• Phantom reads.
  
  
  Displaying Locking Information
  http://msdn.microsoft.com/en-us/library/aa213025(SQL.80).aspx
  
  
  Deadlocking (What's Deadlock?)
  http://msdn.microsoft.com/en-us/library/ms177433.aspx
  

Minimizing Deadlock (How to avoid dealock?)
http://msdn.microsoft.com/en-us/library/ms191242.aspx

Detecting and Ending Deadlock
http://msdn.microsoft.com/en-us/library/ms178104.aspx

Handling Deadlocks
http://msdn.microsoft.com/en-us/library/ms177453.aspx


Optimizing Server Performance Using Memory Configuration Options
http://msdn.microsoft.com/en-us/library/ms177455.aspx


How to resolve a deadlock - SQL Server technical bulletin
http://support.microsoft.com/kb/832524/en-us

• Start SQL Server Enterprise Manager.
• Select, and then right-click the server.
• Click Properties.
• Click Startup Parameters.
• In the Startup Parameters dialog box, type -T1204 in the Parameters text box, and then click Add.
• In the Parameters text box, type -T3605, and then click Add.
• Click OK.