We have 650 site collections all in one Content DB with 800+ GB in size.
Because of this huge size, performance goes down and we have decided to split the DB into 10 different content DBs with maximum 80 GB per content DB.
We can use Move-SPSite Powershell command to move one Site collection to destination database.
But as in our case we have 650 site collections, and we want to move 65 site collections to one content DB. And in this way, we will split into 10 different content DBs.
All we want to do this by Powershell. What is the best possible way to do this?
1. Is there any command to move multiple site collections at ones?
2. Is there Powershell command to create content DB?
Any good suggestion can help?