Automate SQL Server discovery and assessment to accelerate migration to AWS
SQLServerTools is a repository dedicated to helping customers migrate their workload into AWS. The aim of this project is to ease the journey and make migration easier through automation and tooling.
https://app.smartsheet.com/b/form/8d23ba71313048b884876896b30a68d9
The tool consists of two main components: RDS Discovery and SQL Server Assessment.
- RDS Discovery ( RDS Compatability check)
- SQL Server Assessment
The following sections will discuss each of the previous tools.
The RDS Discovery Tool is a lightweight tool that provides the capability to scan a fleet of on-prem SQL Servers and does automated checks for 20+ features. It validates supportability of the enabled features on RDS and generates a report that provides recommendations to migrate to RDS, RDS Custom or EC2 compatible.
You can perform the initial assessment with RDS Discovery:
- Gather a detailed SQL Server inventory that includes SQL Server version, edition, features, and high availability configuration such as FCI and Always On availability groups.
- Assess Amazon RDS compatibility.
- Identify SQL Server Enterprise edition features in use.
The SQLServerAssessment Tool (SSAT) streamlines the evaluation of your on-premises SQL Server workloads to find the necessary system utilization for proper sizing on Amazon RDS. SSAT efficiently measures CPU, memory, IOPS, and throughput usage over a specified time frame, providing tailored suggestions to right-sizing your SQL Server on AWS. This tool is capable of assessing both single and multiple SQL Server instances.
The tools can run independently or in sequence. If you are starting from square one, we suggest starting with RDS Discovery where you capture all of your on-prem SQL Server features and determine if your fleet is RDS, RDS custom compatible, or maybe a combination of both.
After running the RDS Discovery tool, you can run the SQLServerAssessment (SSAT) tool to understand your SQL Server load in terms of CPU, Ram, and IOPS to right-size your SQL Server workload. SSAT is able (by default) to read the output generated from RDS Discovery or you can run pass on a list of servers that you would like to run an assessment against.