Disk Advice

• koalas

  Newbie

  Points: 1

  More actions

  November 28, 2011 at 3:04 am

  #252763

  Trying to configure SAN drives for a SQL installation to use for Navision.

  Currently 650GB Data / 200GB Logs (9 Files), and from what I've read Navision does use TempDB quite a bit, although it's size stays at 15GB

  I'm moving the files to a new SAN. I've got 10 drives to use (6Gbps / 10,000 RPM / SAS)

  And I'm trying to decide between RAID10 for all of the drives and then just carving out LUNs for each of the components,

  or if I should do something like

  6 Disks - Raid 10 - Data

  2 Disks - Raid 1 - OS

  2 Disks - Raid 1 - Logs

  Then carving out a separate LUN for the TempDB on one of those Raids. (Backups are stored elsewhere)

  Any advice? Thanks very much.

• HowardW

  One Orange Chip

  Points: 29109

  More actions

  November 28, 2011 at 3:31 am

  #1413314

  Sounds reasonable considering you only have 10 disks to play with. If it was me, I'd be asking for a couple more disks for the logs, so you could make that RAID 10 as well.

• Ignacio A. Salom Rangel

  SSC-Insane

  Points: 20443

  More actions

  November 28, 2011 at 6:23 am

  #1413390

  Here are some links you can check:

  http://technet.microsoft.com/en-us/library/cc966534.aspx

  http://searchsqlserver.techtarget.com/tip/Optimize-disk-configuration-in-SQL-Server

  http://www.brentozar.com/archive/2008/03/sql-server-2005-setup-checklist-part-2-after-the-install/

  http://www.sqlskills.com/BLOGS/KIMBERLY/category/Transaction-Log.aspx

  Good luck!

  ---

  
  
  My blog