SQL Server Disaster Recovery

You are here: Home » Overview » SQL Server 2000 » SQL Server 2000 Memory

SQL Server 2000 Memory

The Buffer Cache and Log Cache

Buffer Cache – Within the buffer cache are a pool of buffer pages into which data pages are read. This is where data can be modified.

Log Cache – Within the log cache are buffer pages. Whenever a change is made to a record within the buffer cache, a corresponding log record is put into the log cache to record the modification as well as the transaction recording the modification.