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.
Traditional monitoring tools find it difficult to securely monitor the On-premise and Cloud based SQL Servers. The DBAs typically need to run multiple monitoring tools that are not integrated and are disparate in functionality and reporting. In addition, monitoring infrastructure needs to be deployed into multiple sites and DBAs need to be trained to support multiple monitoring tools.
The trend that I’m seeing with my customers is that there is now a willingness to consider the Cloud for the deployment of mainstream database applications, especially if it’s a green fields project. In fact, some of my customers have already made the move and have deployed multiple SQL Servers in Amazon AWS and have