InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 15:10:50 GMT20http://www.sqlservercentral.com/Forums/Topic1370286-149-1.aspxSQl doesn't drop it's memory usage unless restarted or the server is under memory pressure or max server memory is reconfigured to a low value. Please read chapter 4 of that book.Wed, 10 Oct 2012 03:05:55 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1370286-149-1.aspxQuit right Let me check in the testing environment.One thing more. Now i am in another situation.In Production i have set 11 GB to MAXIMUM and 7 Gb to MINIMUM as mentioned in my earlier replies and when i ran my queries (Heavy load queries).it touches to 11 GB and after that with out completion's of query memory drop down to 2 to 3 GB. And my query stuck because 1) Memory drops 2) Query required memory and there is no memory.Why this is happening.ThanksMalik Adeel Imtiaz Wed, 10 Oct 2012 02:58:53 GMTadeel.imtiazhttp://www.sqlservercentral.com/Forums/Topic1370286-149-1.aspxAgain, you do not need /3gb for memory usage above 4GB. That's the /PAE switch and the AWE settings alone. With 16 GB memory, /3GB can be harmful as it reduces the number of page table entries you have and can result in memory issues for the OS.Chapter 4: [url]http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/[/url]Wed, 10 Oct 2012 02:22:01 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1370286-149-1.aspxActually first we have tried with out /3g switch and without /3g switch that we have noticed that AWE memory did not cross 2 GB memory.After that we have enabled /3g switch and AWE memory crosses 5 GB.Please see attachment.Wed, 10 Oct 2012 01:43:42 GMTadeel.imtiazhttp://www.sqlservercentral.com/Forums/Topic1370286-149-1.aspxIf you have 16 GB of memory, you do not want the /3GB switch enabled, it can be harmful. I suggest you remove that switch. You just need the /PAE and AWE enabled within SQL Server.Wed, 10 Oct 2012 01:05:44 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1370286-149-1.aspxDear Gila Monster,Thank you so much for your great support and time.ThanksMalik Adeel ImtiazTue, 09 Oct 2012 22:58:18 GMTadeel.imtiazhttp://www.sqlservercentral.com/Forums/Topic1370286-149-1.aspxI have resolved the problem.....I have added /3g switch with / PAE and restart the server. and problem has been resolved.Thank you so much for your support.ThanksMalik Adeel ImtiazTue, 09 Oct 2012 06:26:32 GMTadeel.imtiazhttp://www.sqlservercentral.com/Forums/Topic1370286-149-1.aspxWindows 2003 32 Bit Enterprise Edition.PAE switch is enabled.Tue, 09 Oct 2012 06:11:44 GMTadeel.imtiazhttp://www.sqlservercentral.com/Forums/Topic1370286-149-1.aspxIs the PAE switch present in boot.ini? (or is it a 64-bit OS?)Tue, 09 Oct 2012 05:56:26 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1370286-149-1.aspxI already restarted the services and complete server restart .But still no results.Tue, 09 Oct 2012 05:42:12 GMTadeel.imtiazhttp://www.sqlservercentral.com/Forums/Topic1370286-149-1.aspxSetting AWE on requires a service restart to take effect.Tue, 09 Oct 2012 05:25:28 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1370286-149-1.aspxDear All,I have 16 GB server physical ram windows 2003 EE 32 Bit.I want to enable AWE with :-Minimum 7000 MB means 7 GbMaximum 11000 MB means 11 GB but when i run. [b][i][u]dbcc memorystatus[/u][/i][/b] it shows me old values.Please help me in this regard. I will be obliged.Please find attached screenshot.ThanksMalik Adeel ImtiazTue, 09 Oct 2012 04:16:26 GMTadeel.imtiaz