Try my app Expense Manager @ google play and amazon store.

Wednesday, July 4, 2012

Buffer Cache and Log Cache in Sql Server

Buffer cache is a memory pool in which data pages are read. It 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 the indication of more physical memory requirement on the server.

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.

No comments:

Post a Comment

Follow by Email

Google+ Badge