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.
| 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 |
 |
|
|
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 |
|
|
|
|
|
|
Best memry config on 4 GB ram and 32 bit OS?