Поделиться через

What’s in Enterprise only? (up to 2TB of memory)

  • Статья

Beginning with SQL Server 2008 R2, there’s a significant difference in the amount of memory that SQL Server can allocate from the OS to its buffer cache (Buffer Pool). An Standard Edition will not grow it further than 64GB, no matter how much physical memory is available to the system on which the instance of SQL runs. That is a limit imposed in the code (hardcoded). The Enterprise Edition though, can allocate up to 2TB for the buffer pool (provided the maximum limits set by the OS are not lower than those 2TB.)

Therefore, if you want your instance of SQL Server to cache in memory over 64GB worth of data, not only you will need an edition of Windows that supports that amount of physical memory, but also will require SQL to run an Enterprise Edition (or a Developer Edition or an Evaluation Edition, both of which behave exactly like the Enterprise does. The only difference among them three is their licensing.)

This post is part of the a series I decided to call “Understanding the value of the Enterprise Edition, one feature at a time” which I started in September 2011 and will grow on a weekly basis, having a new post incorporated to the family every Friday.

Comments

  • Anonymous
    November 20, 2011
    I think you mean 2 TB and not 2 GB a specified in the article!

  • Anonymous
    November 21, 2011
    There is a mistake in: "The Enterprise Edition though, can allocate up to 2GB for the buffer pool", 2GB should be 2TB.

  • Anonymous
    November 28, 2011
    Is this a typo? "The Enterprise Edition though, can allocate up to 2GB for the buffer pool (provided the maximum limits set by the OS are not lower than those 2TB" The first number, should that be 2TB?

  • Anonymous
    December 18, 2011
    It was a typo, yes. The original post has been corrected already, thanks to your feedback. Cheers!