SQL Server AWS Analysis & Planning

A flexible software model is a core part of your business; load comes in spikes and you need to be able to respond rapidly to changing demands from users. Peak business loads aren’t enough to justify buying additional hardware, and additional SQL Server licenses, for your data center. Amazon Web Services (AWS) provide flexible ways to scale up and out in response to customer demand. As many people have discovered, the same rules for configuring SQL Server locally don’t always apply in the cloud.

Brent Ozar PLF has deep experience tuning SQL Server performance in AWS. We work with your team to find potential issues before you’re in the cloud, provide explanations, and offer strategies to mitigate and remove the issue.

During the analysis, we’ll examine your SQL Server environment, establish baselines, and discuss how you can monitor performance once you’re in AWS. With that baseline in place, you will be able to reliably track performance and make effective decisions about scaling up or out. After the analysis, we’ll cover the steps you need to take to move your SQL Server environment into AWS. During the planning stage, we’ll look at the environment analysis and cover strategies to move your applications into the cloud.

Once the analysis and planning is complete, you’ll have a performance baseline, action plan, road map to move into AWS, and knowledge of configuration best practices and the pitfalls you may find in a cloud deployment.

How We Help

We’ve got real-world experience helping Amazon EC2 customers by improving disk performance, configuring replication, designing scale out strategies, and architecting high availability and disaster recovery strategies. In every situation we took advantage of the options available in AWS and used a combination of best practices for SQL Server and AWS to build solutions that perform well and scale.

Contact Us

If you’re considering a move into AWS, or you’re already there and want to make sure your SQL Server is running at peak performance, contact us. In just a few days we can examine your environment, cover best practices, and put together a plan to get you up and running in AWS.