SQL Server’s primary components are:
• Relational Engine
• Storage Engine
• SQL OS
Relational Engine: The Relational Engine, often known as the query processor, is a component of SQL Server that determines what your query needs to perform and how to execute it best. It oversees query execution by requesting data from the storage engine and processing the results.
The Relational Engine includes the following components:
• Cmd Parser
• Optimizer
• Query Executor
Relational Engine Tasks:
- Query Processing
- Memory Management
- Thread and Task Management
- Buffer Management
- Distributed Query Processing
Storage Engine: The Storage Engine is in charge of storing and retrieving data from the storage system (Disc, SAN, etc.).Let’s concentrate on the concepts to learn more.
The storage engine is made up of the following components:
• Access Methods code
• Buffer Manager
• Transaction Manager
SQL OS: This is located between the host machine (Windows OS) and SQL Server. The SQL OS manages all database engine activities. It is a highly flexible operating system with a sophisticated API (application programming interface) that enables automatic locality and improved parallelism. SQL OS provides many operating system services, such as memory management, which deals with buffer pools, log buffers, and deadlock detection via the blocking and locking structure. Other services include exception handling and hosting for other components, such as the Common Language Runtime (CLR).