Category: AWS

AWS EC2 SQL Server Clustering
Posted by Rob Risetto on August 28, 2014

Ok so you can’t actually setup a failover cluster in the traditional sense on Amazon Web Services (AWS) EC2 instances (virtual machines). Essentially AWS does not provide a disk storage option that allows you to provision cluster aware, shareable disk devices.

Continue Reading →

Improve the Restore Performance on AWS
Posted by Rob Risetto on January 20, 2014

Following on from my backup performance post, the next challenge was trying to restore a backup on the mirrored server within a reasonable time. In this case, a reasonable time was 3 to 4 hours as opposed to 12+ hours. Again the issue we faced on AWS was the 39 MB/sec throughput limit per high

Continue Reading →

SQL Backup Performance on Amazon AWS
Posted by Rob Risetto on January 05, 2014

Up until now my exposure to Amazon cloud services was purely article based, however recently I was engaged by a client to assist in improving the backup and restore performance for a 700GB SQL Server database residing on a SQL Server VM provisioned in the Amazon AWS cloud service.

Continue Reading →