Which Windows Operating System To Get for DB Server?
I need to get a dedicated sql server 2005 box and am not sure the best operating system. These are my choices:
Windows Server 2003 Enterprise - 32 bit
Windows Server 2003 Enterprise - 64 bit
Windows Server 2003 R2 Enterprise - 32 bit
Windows Server 2003 R2 Enterprise - 64 bit
This is the server I'm thinking of getting -
Dual Woodcrest Series - SATA Dual Intel Woodcrest 5130 Dual Core Processors 2 x 500GB Hard Drive 4096 MB RAM
Currently, I have my IIS web server and sql server 2005 on the same machine and it's just too bogged down. That one runs windows 2003 standard 32 bit on a Dual Xeon 2.8GHz Processor 2 x 80GB Hard Drive 4096 MB RAM
For SQL Server assuming that you will only be running that get 64bit 2003 Enterprise. You really can't go too wrong and you don't have enough memory to exhaust any of those options.
The 64bit may help a bit but if you are REALLY serious about DB speed perhaps go for SAS / SCSI with more drives instead of 2 larger 500gb drives.
Raid-1 with 2 36gb drives for the transaction logs and Raid 5 with 3 or more servers or if you can afford it Raid 10. Either way if possible split OS from trans logs from DB. Same is true for Oracle as well.
Get Windows 2003 Standard with 64 bit running SQL 2005 will be 3 times faster than under 32 bit, everything being equal. No need for Enterprise versions unless you need their features. Microsoft is rich enough