SQL2019 STANDARD max memory is 128Gb yet my Bufferpool exceeds this value

• PearlJammer1

  SSCrazy Eights

  Points: 8485

  More actions

  February 19, 2025 at 2:35 pm

  #4541292

  Reading the Microsoft documentation it says SQL2019 STANDARD EDITION has a max memory of 128Gb which you can install.

  When i run Glen Berry's SQL2019 diagnostics scripts i get a breakdown like this:

  MEMORYCLERK_SQLBUFFERPOOL =  132998.67MB

  CACHESTORE_SQLCP = 12067.40 MB

  I wont list the rest of the memory breakdown as this already exceeds the 128Gb Microsoft say SQL2019 can use - the actual server has 667Gb of memory installed.

  How can the buffer pool have that much memory allocated when Microsoft the max memory will be capped at 128Gb ?

  • This topic was modified 3 months, 1 week ago by PearlJammer1.

• ratbak

  Default port

  Points: 1407

  More actions

  February 19, 2025 at 4:48 pm

  #4541359

  Is buffer pool extension enabled?

  SQL Server Standard edition allows a maximum buffer pool extension size of four times the value of max server memory.

   

• PearlJammer1

  SSCrazy Eights

  Points: 8485

  More actions

  February 19, 2025 at 5:12 pm

  #4541382

  I don't believe it is

  when i run

  select * from sys.dm_os_buffer_pool_extension_configuration

  it is showing as Disabled