Sign in
Categories
Your Saved List Become a Channel Partner Sell in AWS Marketplace Amazon Web Services Home Help
ProServ

Overview

  1. 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.
  2. 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.
  3. 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.
  4. 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.
  5. 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