July 23, 2007 at 3:56 pm
I am using SQL Server 2005 sp2 EE on Windows server 2003 SP1. I have 32GB RAM, PAE AWE enabled. sp_configure shows max server memory of 30GB. But my diagnostic tool (Spotlight) shows 26.3GB in use and never goes higher. Any ideas why SQL won't use the remaining 3GB memory?
Thanks
Matto
July 23, 2007 at 11:05 pm
Your database server doesnot use more than 26GB of memory. If you want try monitoring the memory usage with Total server memory and target server memory counters.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
July 24, 2007 at 1:55 am
The 3 GB would be used up by the OS, other processes running on the server etc. Like Sugesh said, see the SQL counters and see exactly what SQL is use. How much free memory is available to the OS?
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
July 24, 2007 at 5:59 am
Crispin, He says that 32Gb of RAM is available and 30GB has been set to SQL server out of which 26 is being used and around 3GB is not.
If i am wrong correct me.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply