MS SQL - Locking

2011. 2. 22. 17:09System/SQL


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

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.