Components of the SQL Server Engine
Figure 1-2 shows the general architecture of SQL Server, which has four major components. Three of those components, along with their subcomponents are shown in the figure: the relational engine (also called the query processor), the storage engine, and the SQLOS. (The fourth component is the protocol layer, which is not shown.) 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 1-2. The major components of ...
Get Microsoft® SQL Server® 2008 Internals now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
