I'm currently hosting in our cloud for customers. Our application uses 5 databases pr customer it's a POS application and we have to comply with gov. regulations so there are constrains.
we decided to use a named instance on the SQL2014 server per customer, thinking about separation safety upgrading and recovery. Working with this model for about 2 years now we are getting up to 40+ hosted installations (instances).
The Sql server 2014 is on a virtualized W2012R2 server . We don't have any problems with performance. We use VEEAM for our backups. basically I'm happy today but we keep expanding so I need to plan for the future.
So some questions to you experts:
- Any comments or thoughts about the model named instances V loads of databases in on instance?
- I want to start clustering and I'm very happy with hyper-V and would like to use that, thought's
- Failover or failover with AG ??
- Shared storage on a NAS with different RAID sets?
- Failover the Hyper-V servers versus just the SQL instances?
- In clustering they talk about instances, do they mean the same named instances that have a limit of 50 pr enterprise server.
Looking forward to you comment's and yes I'm prepared for some corrections from Y'll I'm not new to this but I know there's a lot to learn and what's right today might kill you in the future.