Components of the SQL Server Engine
Figure 2-1 shows the general architecture of SQL Server, which has four major components (three of whose subcomponents are listed): protocols, the relational engine (also called the Query Processor), the storage engine, and the SQLOS. Every batch submitted to SQL Server for execution, from any client application, must interact with these four components. (For simplicity, I’ve made some minor omissions and simplifications and ignored certain "helper" modules among the subcomponents.)
Figure 2-1. The major components of the SQL Server database engine
The protocol layer receives the request and translates it into a ...