One of the database of SQLServer is 444 GB. We would like to split the database to multiple file. What would be the process to split the database?
The best way for us to answer is to first ask you why? What advantage do you intend to gain and why is it an issue when such a database remains in a single file?
I can also tell you that it usually doesn't help performance unless you can guarantee that you have separate sets of physical disks and you've identified those things where such a separation would actually matter. Yep.. it can help a little with contention but fixing the code will do a much better job if you have such contention.
17 People are following this question.