MS SQL - Locking

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

SQL Server, Lock Objects (On Performance Counter)

Locking in Database Engine (SQL Server 2008 R2)


Concurrency Problems

Minimizing Deadlock (How to avoid dealock?)

Detecting and Ending Deadlock

Handling Deadlocks

Optimizing Server Performance Using Memory Configuration Options

How to resolve a deadlock - SQL Server technical bulletin

  • 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.