RDSTools

RDSTools is a powershell based tool created to help and speed up Sql Server on prem migration to AWS RDS. AWS RDS is a cloud-based database service that simplifies database setup, maintenance, and scaling. While AWS provides a range of tools for managing RDS instances, RDSTools aims to make the process even more user-friendly quick and efficient. The Tool has two main components,RDSDiscovery and SqlSererAssessment both are light weight and has very low footprint on your server and or database. .

Discovery

  • Limitation Discovery

    RDS Discovery Tool is a lightweight tool,it provides a capability to scan a fleet of on-prem SQl Servers and does automated checks for 20+features.

  • RDS certification

    validates supportability of the enabled features on RDS, and generates a report which provides recommendation to migrate to RDS, RDS Custom or EC2..

  • RDS Instance Recommendation

    Works On on-prem EC2 and GCP . Azure(coming soon) .

SQL Assessment

The SQLServerAssessment Tool is a lightweight Tool ,It plays a pivotal role in ensuring a successful and cost-effective migration of your SQL Server workloads to Amazon RDS. It achieves this by providing detailed insights into resource utilization, cost optimization opportunities, database-level metrics, and the ability to make informed decisions about instance consolidation /Sharding and caching strategies.

  • RDS Right Sizing,cost optimization and Caching assessment
  • CPU,MEM,IOPS and throughputs collection
  • Agent,agentless and third party agonstic
  • 2008-2019 RDS SQL Version

  • open source and fully transparent

This free, lightweight tool streamlines the evaluation of your on-premises SQL Server workloads, helping you determine the necessary system utilization for optimal scaling on Amazon RDS. It gathers data on CPU, Memory, IOPS, and Throughput usage over a predefined timeframe and offers recommendations for right-sizing on AWS, thereby optimizing your costs. Whether you're working with a single SQL Server instance or multiple instances, this tool performs its data collection directly within SQL Server, eliminating extraneous noise introduced by disk or Perfmon monitoring.

Analysis Report

  • Server Analysis

    Detailed Server Analysis .

  • Consolidation Recommendation

    Comprehensive analysis of possible server consolidation, aimed at boosting efficiency and potentially cutting operational expenses.

  • GEN AI Generated Report

    PDF report, produced via GENAI, which analyzes and summarizes the findings from RDSTOOLS.

RDSTools

The Tool RDSTools can be downloaded from github Github.

Training videos: Rdstools.

RDSTools PDF Presentation: RDSTools.

RDSTools GenAI PDF Analysis Report Sample: RDSToolsAnalysis Report.

For comprehensive analysis of your workload, reach out using the contacts below.