I have some questions/situation and wanted to hear your guys thoughts. Our current set up is a 2005 dual node failover cluster and a 2008 R2 dual node failover cluster. They both have 2 physical servers each. The way the previous DBA set them up is each environment has about 5+ instances on each. The way they licensed it, all the instances have to run on one of the servers and fail over together. They did this for both clusters.
I am proposing going to 2014 and wanted to get your thoughts on a couple of things. The first being with the instance names, I don't want to have to touch our hundreds of apps and thousands of PCs to change that. What would be the best way to set up the new environment and still use the old instance names? Aliases?
Then in regards to failures, I was thinking of doing AlwaysOn availability groups and windows failover. We are going with virtuatlized servers (proposing 2 SANS, have at least one) as well as an off site server. Having 4 or 8 virtual servers and splitting up the resources for those. Would that be our best option? We haven't done anything with 2012+ on a regular basis so this is new to us.
Any thoughts or suggestions would be greatly appreciated.