June 7, 2007 at 8:27 am
Hi All-
We added 24 GB of physical RAM on our sql boxes (entr+sp4) running on win2k3 (/pae switch is enabled). The SQL server was configured to use 10 GB of ram (sp_configure (max server memory (MB)) option).
BUT sql server is not taking the additional ram assigned to it and stays at around 4 GB.
Are there other configuration changes we need to do or will sql server cathc up ?
Regards
June 7, 2007 at 8:42 am
Take a look at the following hotfix and verify that it has been applied:
June 7, 2007 at 9:03 am
Hi - The hotfix is already applied.
Thanks
June 7, 2007 at 11:23 am
Is AWE configured? run sp_configure and look for the AWE row. It should show 0,1,1,1
If it shows 0,1,0,0 then AWE was not configured. Run
sp_configure 'awe', 1
reconfigure with override
If it shows 0,1,1,0 then SQL Server service needs to be restarted for it to take effect.
If you don't see the entry at all, you need to run:
sp_configure 'show advanced option', 1
-SQLBill
June 7, 2007 at 11:44 am
keep in mind you have to use windows perfmon to see if it uses awe and uses more than 4Gb
Taskmanager shows wrong data.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
June 7, 2007 at 12:40 pm
Hi - The awe option is enabled. I used win perfmon to look for SQL Server:Memory Manager--> Total Server memory (KB) counter.
June 7, 2007 at 11:37 pm
did you remove the /3GB parameter in boot.ini ?
Only /PAE should be active.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
June 8, 2007 at 8:11 am
I recently did a lot of research on this. ALZDBA makes good points about removing the /3GB switch and using PerfMon to see what's going on rather than task manager.
Two ideas:
If all else fails, here are the links I used for research:
FIX Not all memory is available when AWE is enabled on a computer that is running a 32-bit version of SQL Server 2000 SP4: http://support.microsoft.com/kb/899761
How to configure SQL Server to use more than 2 GB of physical memory: http://support.microsoft.com/kb/274750/
Large memory support is available in Windows Server 2003 and in Windows 2000: http://support.microsoft.com/kb/283037/
Memory Support and Windows Operating Systems: http://www.microsoft.com/whdc/system/platform/server/PAE/PAEmem.mspx
SQL Server 2000 - Tuning Memory: http://www.microsoft.com/technet/prodtechnol/sql/2000/books/c02ppcsq.mspx
SQL Server 2000 Administrator's Pocket Consultant Configuring and Tuning Microsoft SQL Server: http://www.microsoft.com/technet/prodtechnol/sql/2000/books/c02ppcsq.mspx
Hope this helps!
Carter
But boss, why must the urgent always take precedence over the important?
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply