SQL Database Concepts Question:
Download Job Interview Questions and Answers PDF
What is buffer cash and log Cache in sql server?
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.
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 Interview Questions And Answers
PDF
Previous Question | Next Question |
Do you know what is a Trace frag? Where do we use it? | Explain Differentiate between a HAVING CLAUSE and a WHERE CLAUSE? |