Microsoft KB Archive/45660

= INF: Data Page Cache Management in SQL Server =

Article ID: 45660

Article Last Modified on 2/14/2000

-

APPLIES TO


 * Microsoft SQL Server 4.21a Standard Edition

-



This article was previously published under Q45660



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 &quot;procedure cache&quot; configuration parameter reserves the specified percentage of the cache exclusively for store procedures.

Keywords: kbusage KB45660

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.