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.
'System > SQL' 카테고리의 다른 글
| SQL Server Tuning - DB 테이블의 단편화 검사 (0) | 2011/03/10 |
|---|---|
| SQL Server for cloud computing - Lightweight DB (0) | 2011/02/28 |
| MS SQL - Locking (0) | 2011/02/22 |
| Default datetime argument in stored procedure - SQL Server (0) | 2010/06/14 |
| MSSQL 쿼리로 테이블 목록보는 방법 (1) | 2008/06/20 |
| MS SQL Server 2008 CTP July (1) | 2007/11/16 |
이 포스팅이 도움이 되었다면 구글에서 관련 정보를 찾아 보세요 ^^
Prev
