Max Sql Server Memory Vs Buffer Pool

• luckysql.kinda

  SSCertifiable

  Points: 7816

  More actions

  February 11, 2011 at 2:09 pm

  #245117

  I have 64 GB RAM on my server. My junior DBA forgot to set the maximum server memory = 60 GB recommended in the document. The max server memory is set 22 GB for the sql server. But when i run following query to identify the bufferpool target size then this gives me 59 GB. How come the sql server can use more than the max memory set for this?

  select (bpool_commit_target)*8/(1024*1024) as targetINGB, (bpool_committed)*8/(1024*1024) as CommittedINGB,(bpool_visible)*8/(1024*1024) as bpoolVisibleINGB

  from sys.dm_os_sys_info

  --59GB 59GB 59GB

  -lucky

• Cheetah

  Old Hand

  Points: 332

  More actions

  September 21, 2011 at 7:31 am

  #1384482

  This may help.

  http://www.sqlservercentral.com/articles/Memory/74867/

• HowardW

  One Orange Chip

  Points: 29109

  More actions

  September 21, 2011 at 8:42 am

  #1384539

  Not sure that answers the specific question...

  I've never seen this to be greater than the Max memory setting. What exactly does this output?

  sp_configure 'max server memory (MB)'