IgorMi (5/20/2013)
I have a database with a single file which size is 288GB.I'm dropping the indexes and the data is only 90GB. I added three more files and re-created the dropped indexes. Data is equally distributed on the three files and reaches about 66GB on each. In future all four files will have same size.
Why? What's the purpose of all this work? What do you expect to gain?
I know it is important for the tempdb data files' initial sizes to be equal and with same autho-grow configuration.
Does it matter with the user-database data files? I think no. Anyone against, with suggestion, or to confirm ..you're welcome.
The file recommendations for TempDB mostly do not apply to user databases.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability