September 21, 2009 at 9:21 am
So I get an email from the boss on Sunday.
Turns out that he decided to upgrade the production SQL 2005/Windows 2003 (both 32-bit) from 16gb of RAM to 32gb of RAM.
AWE and the switch in the boot.ini have both been activated in order to get the most utilization from that memory. They were both on before the upgrade.
Now my boss wants me to either remove the switch from the boot.ini or disable the AWE.
He believes that there is no reason for both.
What should I do?
What is the best way to take advantage of the extra memory?
Advice?
September 21, 2009 at 10:16 am
I guess this thread has same topic..
http://www.sqlservercentral.com/Forums/Topic412378-146-3.aspx
Swarndeep
http://talksql.blogspot.com
September 22, 2009 at 12:42 am
Timothy.Cloud (9/21/2009)
So I get an email from the boss on Sunday.Turns out that he decided to upgrade the production SQL 2005/Windows 2003 (both 32-bit) from 16gb of RAM to 32gb of RAM.
AWE and the switch in the boot.ini have both been activated in order to get the most utilization from that memory. They were both on before the upgrade.
Now my boss wants me to either remove the switch from the boot.ini or disable the AWE.
He believes that there is no reason for both.
What should I do?
What is the best way to take advantage of the extra memory?
Advice?
I believe, you shouldn't remove the PAE switch from boot.ini.
September 22, 2009 at 12:55 am
You need to leave the settings as they are, otherwise you would hit problems
To add to this post, if this is a dedicated sql box, I would leave about 3 gig for the OS and set the max memory setting in sql server to 29 GB, so sql server can use the extra memory if needed
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
September 22, 2009 at 2:04 am
Which parameters did you specify in your BOOT.INI file ?
BOL topic "Process Address Space" states :
If there is more than 16 GB of physical memory available on a computer, the operating system needs 2 GB of process address space for system purposes and therefore can support only a 2 GB user mode address space. In order for AWE to use the memory range above 16 GB, be sure that the /3gb parameter is not in the boot.ini file. If it is, the operating system cannot address any memory above 16 GB.
IMO this would leave boot.ini to only use the /PAE parameter.
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
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply