SP_2018 .
asked on
SQL server performance
Hi,
Currently we have OLTP databases running on a physical server with SQL 2008 Version.
We are planning to migrate the databases to SQL 2012 and implement Always ON
Availaibility feature for fault tolerance .
We also have an SSIS server which is our ETL staging box and an OLAP server for users to run complex queries for reporting , which are running on seperate vms . We are facing performance problems due to resource contention and increase in the volume of data.
Our management is planning to buy 2 high end physical server with similar hardware configuration and would like to move the Oltp,Olap and ETL staging(SSIS) on the same server on different instances.
My question is if it would be a good idea to have all the three environments on same server and implement always on feature for all the three instances as a fault tolerance solution..will it work?
Thanks
Currently we have OLTP databases running on a physical server with SQL 2008 Version.
We are planning to migrate the databases to SQL 2012 and implement Always ON
Availaibility feature for fault tolerance .
We also have an SSIS server which is our ETL staging box and an OLAP server for users to run complex queries for reporting , which are running on seperate vms . We are facing performance problems due to resource contention and increase in the volume of data.
Our management is planning to buy 2 high end physical server with similar hardware configuration and would like to move the Oltp,Olap and ETL staging(SSIS) on the same server on different instances.
My question is if it would be a good idea to have all the three environments on same server and implement always on feature for all the three instances as a fault tolerance solution..will it work?
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Also please advise me about implementing Always Availability feature
for multiple instances on a server, ie. if i create 3 different instances
Instance 1. OLTP databases
Instance 2. Staging databases
Instance 3. OLAP database
In case of any of these instances fail will all the instances on the server failover to the secondary server or would just the failed instance switch to the secondary server.
And could all these 3 instances exist on the same server if each instance is allocated
adequate pool of resources .
Thanks