Moving BI and OLTP to the Cloud

To react quicker and more cost effective to the load changes and the necessary hardware planning, we moved over 20 OLTP databases to the Amazon cloud. This involved two SQL Servers with databases mirrored to each other for failover purpose. Before the move, we performed a detailed analysis of the I/O subsystem performance of the Amazon Cloud (I2.large, M2.4xlarge, M3.large) versus the corporate SAN and planned the necessary adjustments to the databases. Upon successful execution, we then moved a 2TB BI system along with all the SSIS Based ETL processing as well.