Well.. my setup. SQL 2008 (not R2), 102 GB of data, with about 1200 transactions/sec. (90% read only). All hard drive SAS 15.K. I do have TWO SQLs if this configuration in active/passive using EMC autostart.
C: RAID1 - o/s and program files (2 x 146 GB) D: RAID5 - SQL data files (4 x 300 GB) with 1 300GB spare E: RAID1 - SQL log files (2 x 300 GB) F: Simple volume - storage of daily backups (which are moved to a central storage server every night). No issues with performance, but ymmv. What happened with the failed RAIDs? I have lost hard drives before and never lost a drive. With Adaptec controllers, it is pretty much swap the hard drive and repair. Repair does degrade performance, but I just failed over to the second SQL server while the repair was in process. Look at www.sql-server-performance.com for tons of information in regards to SQL setups and performance. Also, you may want to look at SSD drives if you have the money. From: Brian Desmond [mailto:[email protected]] Sent: Thursday, October 27, 2011 12:58 PM To: NT System Admin Issues Subject: RE: Favorite DB hard drive config? This isn't about favorites, it's about workload requirements, business continuity requirements, and what solution will meet those and other requirements (e.g. cost). Thanks, Brian Desmond [email protected] w - 312.625.1438 | c - 312.731.3132 From: Tom Miller [mailto:[email protected]] Sent: Thursday, October 27, 2011 3:49 PM To: NT System Admin Issues Subject: Favorite DB hard drive config? Hi Folks, I've been watching the various recent threads about RAID and disk configurations. I've been burned several times on RAID 1 and RAID 5 configs. A drive fails, and so doe the entire array. So much for RAID. That said, I'm soon to build a new database server (SQL, Windows 2008). There will be a number of large databases on the system (maybe 1T to start). What are your suggestions? I recall someone mentioned an IBM server that had some sort of "grid" disk redundancy and that sounded cool. Just looking for your thoughts on this. I usually by Dell but any vendor is fine. Tom Confidentiality Notice: This e-mail message, including attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure, or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected] with the body: unsubscribe ntsysadmin ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected] with the body: unsubscribe ntsysadmin ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected] with the body: unsubscribe ntsysadmin
