MS SQL Server Architecture

Intermediate Updated March 20, 2025

🧬 MS SQL Server Architecture

At its core, SQL Server consists of several key components working together:

+-------------------------------------------------------+
|                   Client Applications                 |
+--------------------------+----------------------------+
                           |
                           v
                 +--------------------+
                 |  SQL Server Engine |
                 +--------------------+
                 |  Query Processor   |
                 |  Storage Engine    |
                 |  Transaction Mgr   |
                 +--------------------+
                           |
           +---------------+-------------------+
           |                                   |
   +----------------+                  +----------------+
   | Database Files |                  | Log Files      |
   +----------------+                  +----------------+
  • Relational Engine: Handles query parsing, optimization, and execution.
  • Storage Engine: Manages data access, storage, and indexing.
  • SQL OS: Manages memory, I/O, and scheduling for DB operations.