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 and optimize SQL Server Analysis Services (SSAS) before and after migrating to Amazon EC2
Capture documentation and data lineage to prepare for migrations and for compliance with data regulations
Compare schema and databases, analyze object dependencies, and conduct disk space optimization
Standardize and optimize SSIS components before and after migration to Amazon EC2
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.