INF: Data Page Cache Management in SQL Server

ID: Q45660

The information in this article applies to:

Microsoft SQL Server version 4.2 for OS/2

The following information describes how SQL Server manages its data page cache.

Pages are flushed at checkpoint time or when a page buffer is needed and no free buffers are available. When a page must be stolen, the least recently used page is chosen. No weights are used for dirty versus clean or index versus data, although clean pages are NOT written to disk.

The cache for stored procedure pages is managed in the same way as the data page cache. However, the two functions do not compete with each other for cache pages because the "procedure cache" configuration parameter reserves the specified percentage of the cache exclusively for store procedures.


Keywords          : kbusage SSrvServer 
Version           : 4.2
Platform          : OS/2 
Issue type        :

Last Reviewed: March 6, 1999