Other Enhancements
SQL Server 7.0 made several changes and modifications to 6.x read aheads and locking management which have been continued in SQL Server 2000. These changes improve the overall performance and concurrency of both SQL Server 7.0 and SQL Server 2000.
Read-Ahead Logic
Read-ahead logic was introduced in SQL Server 6.5. The purpose of read aheads is to read data pages from the hard drive into memory (cache) before an executing query requests the data page. Read aheads tend to benefit queries that are retrieving sequential type or range information. The 6.5 read-ahead logic does the page retrieval job quite well, retrieving 16KB extents into memory prior to a query requesting them. In 6.5, read aheads are triggered using several configuration ...
Get Microsoft® SQL Server™ 2000 DBA Survival Guide, 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.
