• All About Backups
• SQL Server 2000
  • Overview
  • Types of Failure
  • Recovery Models
  • System Databases
  • Backup Types
  • Database Files
  • Memory
  • Configuration
  • Troubleshooting
  • MSDB Tables
• SQL Server 2005
• SQL Server 2008 (Late 2008)

SQL Server 2000 Memory Components

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.