I've read a lot of the posts here and it has been most helpful but the database server drive recommendations do seem to be situation specific. My situation: Dell PE 2900 16gb RAM, 1 quad core 2.5ghz cpu (for now), 8 + 2 drive bays, Sql Server 2005 Standard - how many users? 25 concurrent users - how big are the databases? 2 databases , 1 - 60gb, 1 - 600gb - oltp or dss? 90% oltp, 10% dss - how much read versus write actity? 66% read, 33% write - when running reports/batch jobs how much data would be read? largest table (Account Master) is 4.6gb and it is hit in every job/report - if you know then what sort of IO rate do you need for your apps? Don't know. What I can say is that the oltp users are on the other side of a VPN tunnel over 10mb Internet connection and that is where I need to focus my performance. I need to fill up the 10 drive bays with some RAID configuration/s of: OS & Binaries, Data, TLogs, Tempdb? I have two Drive Choices for the 10 bays (max out while I have the budget): 450gb 15K SAS, 1tb 7.2K Nearline SAS I considered the 1tb 7.2k Nearline SAS due to $ savings and increased capacity but am waffeling due to possible performance decrease? What would be your suggestions? Much Thanks, Briang
I posted this question in three forums. This was one replyfrom another forum. Sharing the info. Hope Mr. Harvey doen't mind. -------------------------------------------------------------------------------------------------------------------- I hope you will be running the 64-bit version of SQL Server. With 10 drive bays I might go for one mirrored pair for the OS and paging, the C: drive in other words; a second mirrored pair for database log files, and the other six drives in a RAID 10 set. Allocating dollars, the log drives would be the first place to use the high performance drives. If you also used them for the data in the six drive RAID 10 set that would only give you 1.35GB. Since you are already at 6.6 GB of data I would sat that is marginal and would probably go for the slower, higher capacity drives for the data. However I would make certain to get six; you would have enough space with fewer, but extra spindles means more performance. I would go with whatever is cheaper for the C: drive. The log and data for tempdb would be split the same way log and data are for the other databases. Roy Harvey Beacon Falls, CT