InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 04:12:53 GMT20http://www.sqlservercentral.com/Forums/Topic1136200-1550-1.aspx[quote][b]murugan.shanmugam (12/5/2012)[/b][hr]Hi,Server 32 bit or 64 bit and awe enabled?[/quote]Irrelevant to this question.Year and a half old threadWed, 05 Dec 2012 06:27:05 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1136200-1550-1.aspxHi,Server 32 bit or 64 bit and awe enabled?Wed, 05 Dec 2012 06:08:09 GMTmurugan.shanmugamhttp://www.sqlservercentral.com/Forums/Topic1136200-1550-1.aspxMax memory settings controls only the max size of buffer pool(paged memory).So in short the memory of 234752KB comes from 28 GB max setting.Tue, 05 Jul 2011 06:47:15 GMTSachin Nandanwarhttp://www.sqlservercentral.com/Forums/Topic1136200-1550-1.aspxhello experts,got a server with 32GB of RAM, configured max memory as 28GB.with this query --> "select session_id, requested_memory_kb, granted_memory_kb, required_memory_kb from sys.dm_exec_query_memory_grants"Result : session_id requested_memory_kb granted_memory_kb required_memory_kb---------- -------------------- -------------------- --------------------66 234752 234752 4864here is my question --> is the mermory 234752KB comes from the 28GB i configured for SQL server or from 4GB?Thanks in advance.Mon, 04 Jul 2011 21:51:10 GMTArt-251407