InstantForum.NET v4.1.4SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 20 Mar 2010 09:16:19 GMT20http://www.sqlservercentral.com/Forums/Topic809057-146-1.aspxOn a 32-bit server Task Manager does not know about memory above the 4GB line. If you enable AWE you will have to look in the SQL Errorlog file for a message at startup time that says if AWE memory has been allocated. If you want to see some of the impact of using AWE ther aer performance counters that can tell you this.It is worth searching some of the many threads on this subject for further advice.Wed, 28 Oct 2009 04:25:49 GMTEdVassiehttp://www.sqlservercentral.com/Forums/Topic809057-146-1.aspx[quote][b]Eric1208 (10/27/2009)[/b][hr][quote][b]San-847017 (10/26/2009)[/b][hr]Yeah...If it's 32 bit you will have to enable AWE option.In 64 bit it's not necessary.[/quote]I enabled AWE option but still couldn't increase server memory.[/quote]When you say you cant set it more than 2gb. can you literally not set a value higher than 2gb and your getting an error message or are you reading the default value (its something stupidly high) as 2gb and think you cant make it more?Tue, 27 Oct 2009 03:59:51 GMTAnimal Magichttp://www.sqlservercentral.com/Forums/Topic809057-146-1.aspxI hope you have Window server 2003 Enterprise Edition/PAE enabled in boot.ini?Have you Enabled the Lock Pages in Memory Option (Windows)?Please check the below URL for more details about Enabling AWE and Setting Min-Max Memoryhttp://technet.microsoft.com/en-us/library/ms190673.aspxTue, 27 Oct 2009 00:23:25 GMTjagadeesanpvhttp://www.sqlservercentral.com/Forums/Topic809057-146-1.aspx[quote][b]San-847017 (10/26/2009)[/b][hr]Yeah...If it's 32 bit you will have to enable AWE option.In 64 bit it's not necessary.[/quote]I enabled AWE option but still couldn't increase server memory.Tue, 27 Oct 2009 00:16:43 GMTEric1208http://www.sqlservercentral.com/Forums/Topic809057-146-1.aspxMy server is window server 2003 and 32 bit.Tue, 27 Oct 2009 00:13:11 GMTEric1208http://www.sqlservercentral.com/Forums/Topic809057-146-1.aspxYeah...If it's 32 bit you will have to enable AWE option.In 64 bit it's not necessary.Mon, 26 Oct 2009 23:13:45 GMTJoy Smith Sanhttp://www.sqlservercentral.com/Forums/Topic809057-146-1.aspxWhat is you Operating system Edition?Is your system is 32 Bit or 64 Bit?Mon, 26 Oct 2009 23:06:16 GMTjagadeesanpvhttp://www.sqlservercentral.com/Forums/Topic809057-146-1.aspxHi,Is there any way of increasing memory available for SQL Server 2005? Themaximum I can set from SSMS is 2GB. My server has 8GB memory so I would like to set the memory limit to3GB (or even more).--Eric.Mon, 26 Oct 2009 20:30:25 GMTEric1208