We have got one single dedicated Sql Server 2008 R2 box running multiple named instances for different databases for different country per say for UK, France, Germany etc. Overall we have six databases running under their own individual instances in single box. And the box is having very limited memory (as always) 64 GB.
Facts:
- All applications (multi-tenant) connecting database with the separate credentials using ADO.NET
- All databases having their own SSIS packages, SPS etc. I mean, there is no common (shared) data across databases
- There is no stringent security requirement
- All instances are having their own disk. I mean, as of I assume, they don't compete for the same controller
- All the instances are configured with min/max memory settings.(Not sure if it can be done for multiple databases within same instance)
We have been facing performance issues. Apart from exploring other options, one of the option we want to consider is to have all the databases under one instances. Is it a good practical idea? What could be pros/cons? What happens if one of the database is hammered, will it effect other databases in the same instance?
Please share your thoughts, experiences, links, blog, white paper... anything is highly appreciated.
Aucun commentaire:
Enregistrer un commentaire