Amazon RDS Aurora for PostgreSQL Health Assessment
By:
Datavail
At Datavail, we have a team of certified DBAs who have deep knowledge and expertise on Amazon RDS/Aurora for the PostgreSQL environments. Our expert database team will review your RDS/Aurora instance from various aspects to make sure the database is configured for optimal scalability, performance, high availability, monitoring, logging, and alert setup
Overview
- PostgreSQL database tuning recommendation: Based on the database workload needs, we will review the overall database and cluster parameters to maximize throughput and performance. Ensuring the database is optimally configured from parameters related to memory tuning, query tuning, database logging, vacuum, analyze, bloats, and database connections.
- PostgreSQL High Availability review: Depends on your SLA agreements, we review and recommend the overall requirement for the High Availability set up to meet your SLA requirements. Failover strategy and auto-scaling recommendations will also be reviewed.
- PostgreSQL Identification of slow SQLs: We analyze data from the CloudWatch, performance insights, enhanced monitoring, and using our custom scripts to identify problematic SQL. We also identify the Histogram of these queries along with the slowest individual queries, Ttime consuming queries, type of queries and most frequent queries.
- PostgreSQL monitoring and alerts recommendation: We will review patterns from CloudWatch and custom scripts to identify threshold values for various database counters. We also share recommendations on what all CloudWatch metrics and alerts should be set up.
- PostgreSQL Best practices recommendation: We will review and recommend best practices on unused indexes, missing indexes, duplicate indexes, missing primary keys, SQL traffic pattern, connection pattern, partitioning, extensions, database maintenance jobs, and migration to Aurora from RDS.
| Sold by | Datavail |
| Categories | |
| Fulfillment method | Professional Services |
Pricing Information
This service is priced based on the scope of your request. Please contact seller for pricing details.
Support
Datavail is one of the largest database services companies in North America with more than 1,000 data experts. Datavail monitors and manages 300,000+ databases and applications. As an AWS Advanced Consulting Partner, we’ve helped hundreds of customers migrate, optimize, and manage client’s workloads to the AWS cloud. Contact: Ali Dawson, Alliance Director email: ali.dawson@datavail.com mobile: 410-920-8574