Buffer Cache and Buffer Pool

Chaitanya Kiran 776 Reputation points
2024-05-31T14:24:27.79+00:00

Hi,

What is the difference between Buffer Cache and Buffer Pool?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,107 questions
{count} votes

Accepted answer
  1. LucyChenMSFT-4874 2,485 Reputation points
    2024-06-03T01:44:13.2333333+00:00

    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

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Olaf Helper 42,561 Reputation points
    2024-05-31T19:06:17.35+00:00

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

    SQL Server has "Buffer Pool"

    0 comments No comments