ID Number: Q45660
1.00 1.10 1.11 4.20
OS/2
Summary:
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.