We have a suite of applications utilizing SQL Server have the following characteristics:
- Users create/destroy DBs via a UI, so DBs appear/disappear without DBA assistance.
- DBs of the same name can be created for each of the applications (because they're related to the same subject matter and the apps are used by the same set of people)
- DBs are many, but generally small. For example ~70 DBs totaling 28 GB, ~130 DBs totaling 2 GB.
- Only a handful of DBs are in use at any one time.
I've been asked about configuring a VM with three instances to support these three applications. And, while DBAs generally run screaming when the question of multiple instances on a server comes up, I'm wondering whether this is a scenario where multiple instances would be, if not blessed, tolerated.
I do have large physical servers that I run multiple instances on. But, not VMs. So, I'm comfortable managing the multiple instances in this fashion although the idea of doing on a VM made me a bit queasy.