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
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