Link to home
Start Free TrialLog in
Avatar of SP_2018 .
SP_2018 .Flag for United States of America

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
ASKER CERTIFIED SOLUTION
Avatar of Bernard Savonet
Bernard Savonet
Flag of France image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of SP_2018 .

ASKER

Thanks for your reply.

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