Buffer Cache and Buffer Pool

Question

Hi,

What is the difference between Buffer Cache and Buffer Pool?

Answer 1

Hi @Chaitanya Kiran,

Thank you for reaching out and welcome to Microsoft Q&A.

From the official document, we can get the information:

Buffer pool Also called buffer cache. The buffer pool is a global resource shared by all databases for their cached data pages. The maximum and minimum size of the buffer pool cache is determined during startup or when the instance of SQL Server is dynamically reconfigured by using sp_configure. This size determines the maximum number of pages that can be cached in the buffer pool at any time in the running instance.

Hope this can help you well.

Please feel free to share your issue here if you have any confused

Best regards,

Lucy Chen

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

https://docs.microsoft.com/en-us/answers/support/email-notifications

Answer 2

In SQL Server there is nothing called "Buffer cache", may some article author used the wrong term.

SQL Server has "Buffer Pool"