SQL Server Performance

multiple files question.

Discussion in 'Performance Tuning for Hardware Configurations' started by why, Oct 23, 2007.

  1. why New Member

    Our production system will have two MSA70 arrays (plus two disk controllers) with each having 25 disks installed for data files. Other files are on other arrays.
    How should I separate this. I'm thinking each enclosure will have single RAID 10 array of 25 disks. Should I have multiple small arrays ?
    Should I have multiple data files ? Two on each array ?
    How can multiple data files help performance on single big raid 10 array ?

  2. satya Moderator

    What is the database growth in next 3 to 5 years?
    How about transactions such as read and write?
    What kind of high availability you are looking?
  3. why New Member

    This is for OLAP. Database size will probably increase 4 times or so. Updates (writes) only at night. selects (reads) mostly during the day). Failover solution will be mirroring. Since logs files won't be used during the day i'm thinking about putting them on the same array as data files. My concern is about multiple data files per database and their number and placement.

Share This Page