Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Best memry config on 4 GB ram and 32 bit OS?

Author  Topic 

danieldiesel12
Starting Member

4 Posts

Posted - 2011-03-31 : 06:27:04
Hi!

I´m a newbie. What will the best configuration be for a windows server 2003 32 bit OS be like? I´m running SQL SERVER 2008 enterprise.
Is AWE useful if I run 4 GB ram? I often see that that helps when having more than 4 MB. If I´m correct, 2 GB will always be allocated the OS if I don´t tune my settings?
If I can tune it anyway I would prefer that. I do have some bottlenecks regarding peaks in datareads of a table.
I´m not running anything else on this server. I do have a application server and a webserver running against the SQL server.

Best regards Daniel

jeffw8713
Aged Yak Warrior

819 Posts

Posted - 2011-03-31 : 15:59:05
First question I have would be why you chose a 32-bit OS and SQL. Since this is a dedicated server just for SQL there really are only a few reasons why you couldn't go to 64-bit.

With that said, there really isn't much you can do here. You could try setting the /3GB switch to allow SQL Server to access additional memory (up to 3GB). AWE is only useful for accessing memory greater than 4GB on x86 hardware.

Jeff
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2011-03-31 : 16:30:13
Another reason to use 64 bit OS and SQL is that you would have to use the more expensive Windows Enterprise Edition to access more than 4 GB of memory on a 32 bit system. If you are going to spend more money, it's probably better to spend it on more memory.





CODO ERGO SUM
Go to Top of Page
   

- Advertisement -