Chapter 2. SQL Server 2005 Database Engine Architectural Changes
IN THIS CHAPTER
• The SQL Server Operating System (SQLOS)
• Non-Uniform Memory Access (NUMA) Architecture Support
• Query Optimization and Execution
• System Metadata Access and the Security Architecture
• Storage Engine and I/O Changes
SQL Server 2005 is loaded with features related to scalability, reliability, performance, high availability, programmability, security, and manageability. These features and enhancements are the primary drivers for the major overhauls in several areas of the database engine to accommodate a seamless integration throughout. Microsoft has made changes to SQL Server’s memory management, thread scheduling, statistics management, parallelism, ...
Get Microsoft® SQL Server 2005: Changing the Paradigm (SQL Server 2005 Public Beta 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.
