SQLServerCentral / Administering / SQL Server 2005 / How much memory should be allocated to SQL Server ? / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 09:57:53 GMT20RE: How much memory should be allocated to SQL Server ?http://www.sqlservercentral.com/Forums/Topic871759-146-1.aspx[quote][b]Joy Smith San (2/24/2010)[/b][hr]Sometimes application runs very very slow.[/quote]That isn't necessarily insufficient memory. Yes, memory may help, but you should also look at what's running and see what needs fixing/changing to make it run better.Wed, 24 Feb 2010 03:07:05 GMTGilaMonsterRE: How much memory should be allocated to SQL Server ?http://www.sqlservercentral.com/Forums/Topic871759-146-1.aspxThanks,At present only 4GB is allocated. Sometimes application runs very very slow.Wed, 24 Feb 2010 01:42:03 GMTJoy Smith SanRE: How much memory should be allocated to SQL Server ?http://www.sqlservercentral.com/Forums/Topic871759-146-1.aspx12-14 GB. No more (and I'd err on the lower end of that). OS needs memory to manage memory, not good to starve it.Wed, 24 Feb 2010 01:22:20 GMTGilaMonsterHow much memory should be allocated to SQL Server ?http://www.sqlservercentral.com/Forums/Topic871759-146-1.aspxDear All,I have a dedicated server for SQL server database.It has got 16 GB memory, windows server 2003.SQL server 2005 64 bit with SP3.Database size is 260GBThere is no any other application which needs any considerable amount of memory.Approximately 125 users will be accessing SQL server simaltaneously. So, Idealy, how much memory should I allocate to SQL Server ?Thanks in advance.Wed, 24 Feb 2010 00:47:53 GMTJoy Smith San