Links

Reading Pages
http://technet.microsoft.com/en-us/library/ms191475(v=sql.105).aspx

Heap Structures
http://technet.microsoft.com/en-us/library/ms188270(v=sql.105).aspx

Clustered Index Structures
http://technet.microsoft.com/en-us/library/ms177443(v=sql.105).aspx

Nonclustered Index Structures
http://technet.microsoft.com/en-us/library/ms177484(v=sql.105).aspx

Writing Pages
http://technet.microsoft.com/en-us/library/aa337560(v=sql.105).aspx

Buffer Management
http://technet.microsoft.com/en-us/library/aa337525(v=sql.105).aspx

Understanding Pages and Extents
Memory Architecture
Write-Ahead Transaction Log
SQL Server I/O Basics
SQL Server I/O Basics, Chapter 2

Understanding Pages and Extents
http://technet.microsoft.com/en-us/library/ms190969(v=sql.105).aspx

Memory Architecture
http://technet.microsoft.com/en-us/library/ms187499(v=sql.105).aspx


Write-Ahead Transaction Log
http://technet.microsoft.com/en-us/library/ms186259(v=sql.105).aspx

Transaction Log Physical Architecture
http://technet.microsoft.com/en-us/library/ms179355(v=sql.105).aspx
enable_force_flush Option
http://technet.microsoft.com/en-us/library/ee210587(v=sql.105).aspx
Transaction Log Management
http://technet.microsoft.com/en-us/library/ms345583(v=sql.105).aspx


SQL Server 2000 I/O Basics
http://technet.microsoft.com/zh-cn/library/cc966500.aspx

SQL Server I/O Basics, Chapter 2
http://technet.microsoft.com/zh-cn/library/cc917726.aspx

Table and Index Organization
http://technet.microsoft.com/en-us/library/ms189051(v=sql.105).aspx
sys.allocation_units (Transact-SQL)
sys.partitions (Transact-SQL)
sys.data_spaces (Transact-SQL)

Transaction Log Management
http://technet.microsoft.com/en-us/library/ms345583(v=sql.105).aspx

How to: Enable the Lock Pages in Memory Option (Windows)
http://technet.microsoft.com/en-us/library/ms190730(v=sql.105).aspx

Dynamic Memory Management
http://technet.microsoft.com/en-us/library/ms178145(v=sql.105).aspx

Optimizing Server Performance Using Memory Configuration Options
http://technet.microsoft.com/en-us/library/ms177455(v=sql.105).aspx

posted @ 2014-05-23 01:22  princessd8251  阅读(161)  评论(0编辑  收藏  举报