SQL Server DB engine (relational engine), the SQL language is used to describe the problem to the Engine.
- Algebrizer: Algebra, checking the syntax, and converting the query into an internal expression
- Query Optimizer: Queries Optimizer. Use Management Studio or SQL Profiler to view both the estimated and actual query-execution plan graphically or in XML.
- Query Engine/processor: Queries based on the schedule generated by query optimizer
- Storage Engine: Service for query Engine and handle the actual read and write of the disk
- Buffer Manager: Analyze the data page in use to pre-extract the data from the data file to co-exist with the human memory, thereby reducing the dependency on disk I/O
- Checkpoint: A process that writes dirty data pages in memory (modified data pages) to file data
- Resources Monitor: Respond to memory pressure and intelligently delete older query plans from the cache to optimize the query plan
- Lock Manager: Dynamically manages the locked range with the size of the lock to balance the number of locks required
- Sqlos: Responsible for managing all internal resources (direct control of available resources: memory, threads, I/O requests)
SQL Server consists of: