InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 19:34:22 GMT20http://www.sqlservercentral.com/Forums/Topic1062830-391-1.aspxNot sure that answers the specific question...I've never seen this to be greater than the Max memory setting. What exactly does this output?[code="sql"]sp_configure 'max server memory (MB)'[/code]Wed, 21 Sep 2011 08:42:40 GMTHowardWhttp://www.sqlservercentral.com/Forums/Topic1062830-391-1.aspxThis may help.http://www.sqlservercentral.com/articles/Memory/74867/Wed, 21 Sep 2011 07:31:08 GMTCheetahhttp://www.sqlservercentral.com/Forums/Topic1062830-391-1.aspxI 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 bpoolVisibleINGBfrom sys.dm_os_sys_info--59GB 59GB 59GB-luckyFri, 11 Feb 2011 14:09:28 GMTluckysql.kinda