Moving SQL Servers from on-premises to the cloud can bring significant benefits—as well as challenges, especially during the transition.
As an AWS partner with Microsoft Workloads Competency, SentryOne can provide expert guidance as you're migrating SQL Server workloads to Amazon Elastic Compute Cloud (AWS EC2) or to Amazon RDS for SQL Server.
SentryOne solutions not only pave the way for a smoother migration, but also ensure that your Amazon cloud-based workloads are optimized for peak performance.
To provide best-in-class managed services, SentryOne partner Fortified Data needed comprehensive visibility into the performance health, resource consumption, and capacity challenges of complex hybrid and cloud-based customer systems.
Using SQL Sentry across the database environment, including Amazon RDS for SQL Server, Subway reduced the time spent collecting data and diagnosing each production performance problem from an hour to about five minutes, a 92% reduction.
SentryOne provides end-to-end migration and optimization solutions for shifting SQL Server workloads to Amazon EC2 or Amazon RDS.
Monitor workloads before and after migration, establish performance baselines, and optimize production databases
Monitor and optimize SQL Server Analysis Services (SSAS) before and after migrating to Amazon EC2
Standardize and optimize SSIS components before and after migration to Amazon EC2
Conduct unit testing of data before and after migrations with an automated framework for any ADO.NET, OLE DB, ODBC, and REST sources of data
Compare schema and databases, analyze object dependencies, and conduct disk space optimization
Automatic database documentation and data lineage analysis in a cloud solution.
Audit and monitor SSIS and SSRS, and compare on-premises and cloud-based instance configurations
SentryOne is the most capable, scalable solution for optimizing performance of SQL Server—on-premise, in virtual environments, and in the cloud. As an Amazon Technology Partner, we've worked side by side with Amazon engineers to ensure that data professionals have the detailed information they need to proactively manage their cloud-based databases for peak performance, whether on Amazon EC2 or Amazon RDS for SQL Server.
Proactively monitor, diagnose, and optimize SQL Server workloads on Amazon EC2 with SentryOne.
SentryOne leads the industry in performance metrics collected for SQL Server workloads hosted on Amazon, giving data teams unprecedented capabilities for proactively managing performance: