Memory, threads, and internal scheduling
Use these guides to understand how SQL Server stores, accesses, and maintains data on disk.
Use these guides to understand how SQL Server stores, accesses, and maintains data on disk.
Description
Page and extent architecture
guide
organized within data files.
I/O fundamentals
Explains why I/O is core to the engine and discusses efficiency
articles such as drive caching principles. It also discusses I/O
reliability requirements.
architecture and management
guide
physical and logical architecture of the log.
Describes ghost cleanup as a background process that physically
removes rows previously marked for deletion.
Use these guides to understand how SQL Server compiles, optimizes, and executes queries.
Description
Query processing
Describes how the Database Engine processes queries across storage
architectures. It covers optimization and reuse through execution plan caching.
Covers index architecture and fundamentals.
designing effective indexes.
Use these guides to understand how SQL Server manages memory and CPU resources
internally.
Description
Memory management
Describes SQL Server memory architecture and how SQL Server acquires
and uses memory. It includes background on OS virtual memory.
ﾉ
ﾉ
ﾉ