INF: Data Page Cache Management in SQL Server (45660)
The information in this article applies to:
- Microsoft SQL Server 4.2x
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 "procedure cache" configuration
parameter reserves the specified percentage of the cache exclusively
for store procedures.
| Modification Type: | Major | Last Reviewed: | 2/14/2000 |
|---|
| Keywords: | kbusage KB45660 |
|---|
|