what is buffer cache and log Cache in sql server
By j Miracle
buffer cache and memory cachje in sql server.
the meaning of the buffer cash and memory cash is as follows:
Buffer Cache: Buffer cache is a memory pool in which data pages are read. The performance of the buffer cache is indicated as follows: 95% indicates that pages
that were found in the memory are 95% of time. Another 5% is needed for physical
disk access. If the value falls below 90%, it is an indication of more physical memory requirement on the server.
Log Caches: Log cache is a memory pool used to read and write the log pages. A set of cache pages
are available in each log cache. The synchronization is reduced between log and
data buffers by managing log caches separately from the buffer cache.
what is buffer cache and log Cache in sql server (981 Views)