May 27, 2004 at 4:54 am
I've recently installed a new SQL server (Standard Ed) on Win2003. Given that Std Edition is limited to 2 GB of memory I decided to put in 2.5GB to ensure that SQL will at least use the 2GB and have some spare for the OS.
What I've found is the SQL processes are only using 1.7GB ram. Now the databases on here are quite large and very query intensive so I would have assumed it would grab more memory (there are no limitation on the Max memory it can use). I then tried setting the Minimum memory to 2GB but still it just uses 1.7GB?
Any ideas? Seems a waste to have memory not being used?
thanks,
Craig
May 31, 2004 at 8:00 am
This was removed by the editor as SPAM
May 31, 2004 at 9:19 am
I've had a number of 4GB machines and they never go above 1.7GB. It seems that the server algorithms that balance memory with the OS max out here.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply