December 28, 2009 at 6:06 am
Hi
I need to find out the Memory Settings for Sql Server 2005 Developer Edition on Windows 2008 Server (64 Bit) with RAM : 16GB.
While auditing it has been found that Sql Server is not utilizing more than 4 gb of RAM.
Can anyone help me in suggesting the proper configuration settings?
Rgds
Mohan Kumar VS
December 28, 2009 at 6:14 am
I assume you are using 32 bit SQL Server. Have you seen the memory settings on the SQL Instance. Enable AWE and restart the instance.
Look at this Blog Enable AWE Option in SQL Server
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 28, 2009 at 6:25 am
Thanks. Yes, we are using Sql Server Developer Edition 32bit. AWE is already enabled & I've gone through the link provided by you. The setting I have is Min:4096 gb Max:12288. But still performance is the problem.
Rgds
Mohan Kumar VS
December 28, 2009 at 6:30 am
Have you enabled lock page in Memory.
http://technet.microsoft.com/en-us/library/ms190730(SQL.90).aspx
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 28, 2009 at 7:36 am
Mohan Kumar VS (12/28/2009)
Thanks. Yes, we are using Sql Server Developer Edition 32bit. AWE is already enabled & I've gone through the link provided by you. The setting I have is Min:4096 gb Max:12288. But still performance is the problem.Rgds
Mohan Kumar VS
Check the perfmon.msc
see the Discussion
Also check ur application if any indexes required
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
December 29, 2009 at 2:01 am
Thanks for the tips.
December 29, 2009 at 6:13 am
You are welcome !
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 29, 2009 at 10:03 pm
Try /PAE switch to boot.ini
May be the memory restricts happens in the OS.
Surya
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply