Max Sql Server Memory Vs Buffer Pool

  • 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

  • This may help.

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

  • 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)'

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply