DBSTATUS_CACHE_SPILL top-level constant

int const DBSTATUS_CACHE_SPILL

This parameter returns the number of dirty cache entries that have been written to disk in the middle of a transaction due to the page cache overflowing.

Transactions are more efficient if they are written to disk all at once. When pages spill mid-transaction, that introduces additional overhead. This parameter can be used help identify inefficiencies that can be resolved by increasing the cache size.

Implementation

const DBSTATUS_CACHE_SPILL = 12;