September 4, 2009 at 9:57 am
I have a Windows Server 2003 Enterprise Edition Server with 16GB or RAM.
When I go to System Properties it says I am using Physical Address Extension. I have granted the user that SQL server is running as the lock pages in memory right.
I have configured SQL Server to use 12GB of RAM with the plan being to leave 4GB for OS and other tasks.
When I go to task manager I never see the Memory Usage approach anywhere near 14GB, shoot, it doesn't get close to using 1GB. This server is hosting a couple large databases with the biggest one being about 150GB in total.
Any idea how I can confirm that all of this memory is actually available to SQL server? Any idea why it wouldn't be using it?
September 4, 2009 at 10:55 am
have you tried PerfMon? Check things like the buffer and proc cache
_________________________________________________________________________________SQLGeordieWeb:- Jarrin ConsultancyBlog:- www.chrisjarrintaylor.co.ukTwitter:- @SQLGeordie
September 4, 2009 at 10:58 am
See the folowing link,
http://www.sqlservercentral.com/Forums/Topic702953-360-1.aspx
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
September 6, 2009 at 6:03 am
you are using AWE on this 32bit box - in this case task manager has some "nice features" that dont shows all of the memory that sql server is using. Like Querymuthu said you should check out the following topic: http://www.sqlservercentral.com/Forums/Topic702953-360-1.aspx
and I'm recomending this webcast with Christian Bolton - http://sqlbits.com/Agenda/event3/A_walk_down_memory_lane/default.aspx
It will help you to choose a right value for min/max server memory, but afterthis screen I suggest to stay with this 12GB.
after reconfiguring your memory settings you can check following counter: SQL Server: Buffer Manager: Page Life Expectancy - it should be greater then 300 (greater is better).
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply