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