• Note that what you appear to want is not load balancing, but rather restricting the use of resources between databases.

    Using VMs will give you some control, but at the expense of other issues. As TheSQLGuru mentioned, you probably want to engage a consultant if you have no idea how to work with the load. It's not a knock, but rather it's a chance for your to learn a lot in a short period of time from someone else.