#title Storage Engine
[[TableOfContents]]

==== 참고자료 ====
 * attachment:StorageEngine/트랜잭션로그읽기.docx (아는 동생 고희수가 sqler.com에 정리해 논 내용이다. 짜식~ 열심히 하는구만ㅋㅋ)
 * [Null Test]
 * [물리구조]
 * [http://support.microsoft.com/kb/907877 DBCC MEMORYSTATUS 명령을 사용하여 SQL Server 2005 메모리 사용을 모니터링하는 방법]
 * [http://sqlskills.com/BLOGS/PAUL/post/Inside-the-Storage-Engine-Whats-in-the-buffer-pool.aspx Inside the Storage Engine: What's in the buffer pool?]
 * [http://sqlblogcasts.com/blogs/simons/archive/2009/08/31/INSERT-and-UPDATE-loading-practice---The-impact-of-forwarding-pointers-.aspx INSERT and UPDATE loading practice - The impact of forwarding pointers]
 * [http://blogs.msdn.com/sqlserverstorageengine/archive/2006/07/08/under-the-covers-gam-sgam-and-pfs-pages.aspx Under the covers: GAM, SGAM, and PFS pages]
 * [http://blogs.msdn.com/sqlserverstorageengine/archive/2006/06/24/645803.aspx Under the covers: IAM chains in SQL Server 2000]
 * [http://sqlblogcasts.com/blogs/tonyrogerson/archive/2007/06/28/what-is-a-page-split-what-happens-why-does-it-happen-why-worry.aspx What is a page split? What happens? Why does it happen? Why worry?]
 * [http://blogs.msdn.com/psssql/archive/2008/04/08/how-it-works-sql-server-page-allocations.aspx How It Works: SQL Server Page Allocations]
 * [http://sqlnote.com/zbxe/Internal/158 자료형(tinyint & smallint) 물리구조비교]
 * [http://msdn.microsoft.com/ko-kr/library/ms175935.aspx 즉시 파일 초기화]
 * [http://technet.microsoft.com/ko-kr/magazine/2009.02.logging.aspx SQL Server 로깅과 복구의 이해]
 * [http://msdn.microsoft.com/ko-kr/library/ms186981(SQL.90).aspx 8KB를 초과하는 행 오버플로 데이터]
 * [http://technet.microsoft.com/ko-kr/library/ms190969.aspx 페이지 및 익스텐트 이해]
 * [MemToLeave영역에 대한 메모]