Disk Partitions for MDF, Backup files, Maintenance

• AVB

  SSChampion

  Points: 11418

  More actions

  September 22, 2010 at 8:14 am

  #227157

  I'm setting up a new SQL server and I had some general questions about disk partitioning for the data files and backups etc..

  I currently have a RAID - 1 for the LDF files and a RAID - 5 for the MDF files. These are currently set at 64KB Strip Size.

  Although I'm going to implement DB Mirroring I'll still continue to backup the databases to that local server and to another offsite server.

  Will I see any benefit if the backups are written to the RAID-1 vs the RAID-5 ?

  And isn't it beneficial to store the MDF files on a separate partion within that Disk for maintenance purposes like defrag etc.? I'm not sure if I want to mix the MDF files with other files on that disk.

  What about LDF Files...separate partion too?

  Also when creating the partition should that allocation unit size be 64KB as well?

  TIA.

• subbu_e

  SSCrazy

  Points: 2431

  More actions

  September 23, 2010 at 1:52 am

  #1226128

  RAID 1 will give you the better Read performance, however the backup is a write operation it will not give the better performance.

  by standard if you have budget you can go with RAID 10 for you T-Log,Data,index,backup files.

  if you have a less budget then configure RAID 10 for T-Log and Data,index,backup on RAID 5 will give the better performance on 64 KB strip.

  hope this helps.

  Regards,

  Subbu

  http://mssqlforum.wordpress.com

  Regards,
  Subbu
  Click here to Get Speedy answer or solution