Number of datafiles | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Number of datafiles

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? Thanks Esio Nunes
To continue with this thread, check: Luis Martin
Moderator All in Love is Fair
Stevie Wonder
All postings are provided “AS IS” with no warranties for accuracy.