SQL Server Architecture
Storage Engine
The main responsibilities of the storage engine include:
- Managing the files on which the database is stored and managing the use of space in the files.
- Building and reading the physical pages used to store data.
- Managing the data buffers and all I/O to the physical files.
- Controlling concurrency. Managing transactions and using locking to control concurrent user access to rows in the database.
- Logging and recovery.
- Implementing utility functions such as the BACKUP, RESTORE, and DBCC statements and bulk copy.