question

chitrarekhasaha avatar image
chitrarekhasaha asked

Process to split the sqlserver database

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?

datafiles
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Jeff Moden avatar image
Jeff Moden answered

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.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.