SQL Server Performance

Number of datafiles

Discussion in 'Performance Tuning for Hardware Configurations' started by EsioN, Jun 22, 2006.

  1. EsioN New Member

    Considering a database with 80GB (datafile), using a 1+0 array:
    What the best configuration to a performance gain, use 2 files 40gb in the same array, or using one file with 80GB.?

    And the same database (80gb), using a raid 5 instead raid 1+0, best with one datafile or 2 datafiles?


    Esio Nunes
  2. joechang New Member

    multiple files in one file group has very little to do with size directly.
    it is usually used when the arrays are on multiple raid controllers, hence you must have multiple files (do not use os striping for heavy load systems)

    multiple filegroups each with one or more files can be used so the biggest table can get its own file group, possibly indexes on another, and if there is a large amount of text/image data,

    this is so you do not have to defrag the big table

Share This Page