I’m currently in the process of creating hardware requirements for a dream machine to host both an older MSSQL’s databases, be the master server in replication, and house a new database project with heavy reads and heavier writes. Having dealt with disk I/O issues in the past, I tend not to want to have them again, especially for something that will have even more disk writes than reads. It would be nice to have the old stuff and the new stuff seperated so they wouldn’t fight for disk I/O.
I know this will never fly, but I’ll try it anways and see how it goes. :-)
- Some large rack mount chassis with many PCI slots
- 2 2.5Ghz HyperThreading Xeons (expandable to 4)
- 4GB Ram (expandable to 12GB)
- Tempdb: Controller 1 w/ external RAID 1E0
- Existing User DB: Controller 2 w/ external RAID 1E0
- New User DB: Controller 3 w/ external RAID 1E0
- Existing DB Transaction Logs: Controller 4 Channel 0 RAID5
- New User DB Transaction Logs: Controller 4 Channel 1 RAID5
- 44U rack
I’m sure the price tag on all of that will make the hair stand up on any PHB within a mile. Rumor has it that IBM has finally released an EXP400 enclosure that uses the new Ultra320 15,000RPM SCSI drives and a new ServeRAID 6M Ultra320 RAID card to consume them. Yummy.