- Jun 24, 2006
- 3,248
- 1
- 81
I'm building a system to run SQL Server 2005 on, and to develop & test software on. I need fast hard drive performance for building the databases, and running intensive queries. What's the best performance I can get for this, I'd say the max I'm willing to spend on the storage system is $800. Price/performance ratio is important, to maximize the budget.
Note: reliability isn't a concern, no critical data will be stored on this, so I don't see any reason not to go with RAID 0. The primary drive with OS will probably be a single Raptor. The system will be on a Q6600, 8GB DDR2, either Win 2003 64bit or Vista 64bit.
EDIT: I'm shooting for at least 500MB/s read speed. I guess you can achieve this w/ multi-channel scsi, but can you raid across two or more scsi channels? what about with sata II?
What would perform best:
What drive would be preferable if I don't go with Raptors? What controller is recommended (PCI-X has highest bandwidth right?)?
Note: reliability isn't a concern, no critical data will be stored on this, so I don't see any reason not to go with RAID 0. The primary drive with OS will probably be a single Raptor. The system will be on a Q6600, 8GB DDR2, either Win 2003 64bit or Vista 64bit.
EDIT: I'm shooting for at least 500MB/s read speed. I guess you can achieve this w/ multi-channel scsi, but can you raid across two or more scsi channels? what about with sata II?
What would perform best:
- 4x-6x SATA II 7200rpm / RAID 0
- 2x 150GB Raptors / RAID 0
- 2x 15krpm SCSI Ultra320 / RAID 0
- 2x 15krpm SAS / RAID 0
- Other options?
What drive would be preferable if I don't go with Raptors? What controller is recommended (PCI-X has highest bandwidth right?)?