SQL Database Concepts Question:

What is buffer cash and log Cache in sql server?

Tweet Share WhatsApp

Answer:

Buffer Cache: 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 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.

Download Basic SQL Server PDF Read All 113 Basic SQL Server Questions
Previous QuestionNext Question
Do you know what is a Trace frag? Where do we use it?Explain Differentiate between a HAVING CLAUSE and a WHERE CLAUSE?