Final Words

In this chapter, we’ve looked at the general workings of the SQL Server engine, including the key modules and functional areas that make up the engine. We’ve also looked at the interaction between SQL Server and the operating system. By necessity, I’ve made some simplifications throughout the chapter, but the information should provide some insight into the roles and responsibilities of the major components in SQL Server and the interrelationships among components.

Get Inside Microsoft® SQL Server™ 2005, Fourth Edition 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.