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: http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=15113 Luis Martin
Moderator
SQL-Server-Performance.com All in Love is Fair
Stevie Wonder
All postings are provided â€œAS ISâ€ with no warranties for accuracy.

]]>