SQL Server Performance

Number of datafiles

Discussion in 'SQL Server 2005 Performance Tuning for Hardware' started by EsioN, Jun 22, 2006.

  1. EsioN New Member

    Hello. I put this topic in SQL2000 forum, but I'm planning upgrade SQL Server next month.

    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. Luis Martin Moderator

Share This Page