We have a failry large database (around 400GB) that has split into the following:-
1 x .MDF file
1 x .LDF file
9 x .NDF files
All the .MDF and .NDF files are of different sizes (although they do have the same growth increments set, which is 10% and unimited max size).
The log file also has the maximum file size set to the 2TB default.
I'm think, due to the above, that read/write performance is being impacted (although I can't prove it without the tidy-up).
I've attached a screenshot of the current set-up.
What I want to do is to tidy it up (and reset the log file max size to something reasonable).
My thoughts are as follows:
Get rid of all the current .NDF files by pulling them back into the .MDF file
Set up some new .NDF files (I'm not sure how many as yet but i'm thinking keep the 9 to keep the individual file sizes reasonable) with a decent initial size (probably 50GB) and a better growth increment)
Split the .MDF file back into the new .NDF files
Can anyone see any issues with what I want to do or suggest any better ideas?