Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Max Sql Server Memory Vs Buffer Pool Expand / Collapse
Author
Message
Posted Friday, February 11, 2011 2:09 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Saturday, July 19, 2014 8:57 PM
Points: 310, Visits: 650
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
Post #1062830
Posted Wednesday, September 21, 2011 7:31 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, June 3, 2014 8:00 AM
Points: 24, Visits: 271
This may help.
http://www.sqlservercentral.com/articles/Memory/74867/
Post #1178628
Posted Wednesday, September 21, 2011 8:42 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 9:58 AM
Points: 1,225, Visits: 9,646
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)'

Post #1178693
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse