DB Server Hard Drive question

[wbodger]

So, I am looking at building a new DB server and am trying to decide between 15k RPM Ultra 320 SCSI drives and SATA II drives. my understanding is that he IOPS for the SCSO are much higher (like almost double) that of the SATA II drives. Does anybody out there have any concrete experience with the difference between these two setups in a transactional environment?

Thanks!
Willie

 

[mrdenny]

You'll want SCSI drives over SATA for a production system.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog