Before moving sites between content databases, you should know a quantity of your databases for your WebApplication. You can move sites between content databases only if they are in the same WebApplication!

To see information about all your content databases with powershell, you need to enter to PowerShell Console:


The result is something like this:

Id               : 8c4c1d8e-ade2-4325-be64-aaa6ed7a1fdf
Name             : WSS_Content_6529bc39b45f42209cd09ef6fd387d48
WebApplication   : SPWebApplication Name=SharePoint - 36537
Server           : sp10dev\spdev
CurrentSiteCount : 1

Id               : ebc388e9-c10e-4c6c-95e9-3608e4d36f4c      
Name             : SPDEV_WSS_Content
WebApplication   : SPWebApplication Name=SharePoint10 - 80
Server           : sp10dev\spdev
CurrentSiteCount : 4

Item "CurrentSiteCount" shows you a quantity of site collections in the content database. It’s not easy to say which value is the best – it depends on size, update rates, users etc. But if it’s your SharePoint farm, you should know better about site collections.