Bob, Given the number of disks you have to work with - that is probably the config I would use.
My only 'concern' would be performance of the RAID5 for backups - RAID5 isn't optimal for write-intensive applications. But...unless you can scare up another disk so you can go 0+1 for the backups, or maybe go with a RAID1 for backups and leave one drive as a hot spare (if that gives you enough capacity) - I'd say your config is pretty decent. Btw...some decent advice on this site if you want to really segment your databases and go all-out to optimize the SQL performance: http://www.sharepointjoel.com/Lists/Posts/Post.aspx?List=0cd1a63d-183c-4 fc2-8320-ba5369008acb&ID=227 Jim Holmgren Manager of Server Engineering XLHealth Corporation The Warehouse at Camden Yards 351 West Camden Street, Suite 100 Baltimore, MD 21201 410.625.2200 (main) 443.524.8573 (direct) 443-506.2400 (cell) www.xlhealth.com From: Bob Fronk [mailto:[email protected]] Sent: Friday, May 14, 2010 9:04 AM To: NT System Admin Issues Subject: SharePoint - SQL Backend setup I am designing my SQL server for a SharePoint farm. I have an iSCSI array with 15 - 420GB SAS drives. I want to use the array to house the transaction logs, database and backups. My thought is to use two drives in a RAID1 for the transaction logs (420GB), Three drives in a RAID5 for the DB Backups (837GB) and Ten drives in a RAID 10 for the database (2TB). The server will be backed up by DPM, so the DB Backups volume won't need to hold but a day or two of backups. Any SQL gurus see a problem with this setup? BF CONFIDENTIALITY NOTICE: This email, including attachments, is for the sole use of the intended recipient(s) and may contain confidential and/or protected health information. Under the Federal Law (HIPAA), the intended recipient is obligated to keep this information secure and confidential. Any disclosure to third parties without authorization from the member of as permitted by law is prohibited and punishable under Federal Law. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. NOTA DE CONFIDENCIALIDAD: Este facsímile, incluyendo lo adjunto, es para el uso exclusivo del destinatario(s) y puede contener información confidencial y/o información protegida de salud. En virtud de la Ley Federal (HIPAA), el destinatario tiene la obligación de mantener esta información segura y confidencial. Cualquier divulgación a terceros sin la autorización de los miembros de lo permitido por la ley está prohibido y penado en virtud de la Ley Federal. Si usted no es el destinatario, por favor, póngase en contacto con el remitente por teléfono y destruir todas las copias del mensaje original ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
