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 |
|
jmchristy
Starting Member
8 Posts |
 Posted - 2008-03-24 : 19:05:01
|
| Hey guys, got a question regarding hardware configuration for a new SQL server we are installing here. We are migrating from a Windows 2000 standard, SQL 2000 standard box with 4GB of RAM to a Windows 2000 datacenter, SQL 2000 enterprise box with 32GB of RAM.What would be the best way to set this up in Enterprise Manager? Should I just let SQL Dynamically use the RAM or should I select a fixed amount? Also with the processors, should I allow SQL to use all available processors or just 3 of the processors? Also with such a large amount of RAM, I've read people setting there pagefile to 0 so there is no load on the hard drives.Let me know what you guys think, thanks!! |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-24 : 23:21:22
|
| Is it 32-bit or 64-bit machine? You have to set max memory to 28gb in either case but memory configuration is different. Let sql use all processors if it's dedicated for sql. By the way, why still use win2k? And windows doesn't let you set 0 byte page file. |
 |
|
|
jmchristy
Starting Member
8 Posts |
Posted - 2008-03-25 : 08:31:38
|
| This is a 32-bit machine. We have to stick with Windows 2000 and SQL 2000 because of our business system, it is only supported in that environment. Your saying to set max memory to 28GB and allow the rest of the RAM be available to the OS?Thanks! |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-25 : 23:44:53
|
| Yes, OS needs them to manage pae. |
|
|
|
|
|
|
SQL Configuration