Query Tree Cmd parser SQL Server Network Interface

Query Tree Cmd parser SQL Server Network Interface Query Plan Optimizer Query Executer Relational

Query Tree Language event TDS Cmd parser TDS Query Plan Optimizer Query Executer Relational

�공유 잠금 (Shared Lock Mode) – (S) �업데이트 잠금 (Update Lock Mode) – (U)

�커밋된 읽기 (Read Committed Snapshot Isolation) ◦ 반복되지 않은 읽기(Non. Repeatable Read) ◦ 유령

�Professional. SQL Server® 2008 Internals and Troubleshooting (Christian Bolton, JAMES ROWLAND-JONES) �Microsoft® SQL Server®

Slides: 23

Download presentation

Query Tree Cmd parser SQL Server Network Interface Query Plan Optimizer Query Executer Relational Engine Protocol Layer Access Methods Data File Storage Engine Plan Cache Data Cache buffer Manager Buffer Pool SQL 서버의 기본 동작 (SELECT)

Query Tree Language event TDS Cmd parser TDS Query Plan Optimizer Query Executer Relational Engine Protocol Layer SQL Server Network Interface Plan Cache Transaction Log D Data File Access Methods Transaction Mgr Storage Engine Data Cache buffer Manager Buffer Pool SQL 서버의 기본 동작 (UPDATE)

�공유 잠금 (Shared Lock Mode) – (S) �업데이트 잠금 (Update Lock Mode) – (U) �베타 잠금 (Exclusive Lock Mode) – (X) �스키마 잠금 (Schema Lock Modes ) – (Sch-S) (Sch. M) �내부 잠금 (Intent Lock Modes) – (IS)(IU)(IX) �변환 잠금 (Conversion Lock Modes) – (SIX)(SIU)(UIX) �벌크 업데이트 잠금 (Bulk Update Lock Mode) – (BU) 잠금의 종류

�커밋된 읽기 (Read Committed Snapshot Isolation) ◦ 반복되지 않은 읽기(Non. Repeatable Read) ◦ 유령 데이터 (Phantom) �스냅숏 (Snapshot Isolation) �행 버전 관리 (Row Versioning) ◦ Temp DB를 사용 행 버전 관리의 격리 수준

�Professional. SQL Server® 2008 Internals and Troubleshooting (Christian Bolton, JAMES ROWLAND-JONES) �Microsoft® SQL Server® 2008 Internals �Microsoft BOOKS ON LINE 참고 자료 (Kalen Delaney)