Chapter 33. SQL Server Internals
by Ray Rankins
IN THIS CHAPTER
SQL Server Memory Management
SQL Server Process Management
SQL Server Disk I/O
SQL Server Storage Structures
Database Files and Filegroups
Database Pages
Tables
Indexes
Data Modification and Performance
If you are migrating to SQL Server 2000 from versions prior to SQL Server 7.0, you will notice that the physical database architecture in SQL Server 2000 is quite different. The new architecture provides increased performance, better scalability, and improved stability. The new architecture also provides a foundation for features that might be introduced in future versions (for example, table partitioning, intertable clustering, and so on).
Why bother learning about the SQL Server internals ...
Get Microsoft® SQL Server™ 2000 Unleashed, Second 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.
