The goal of database tuning is to optimize application DB queries and engine performance according to how they’re best used, with the ultimate end state being optimal database performance to support system function and end-user experience.

During this engagement, Triumph’s Data Architect will establish a performance baseline for your selected RDS database(s) then perform a hands-on assessment against that baseline. The outcome of the initial phase will be a set of optimization recommendations, including a modernization path and target architecture as relevant. The Triumph team will work with you to prioritize the recommendations and identify a starting point for remediation activities.

Key Objectives:

• Perform assessment activities

        - Application statistics (transaction volumes, response time)
        - Query inventory
        - Database statistics
        - Disk I/O statistics
        - Network statistics

• Perform analysis activities

        - Query tuning recommendations
        - Data modeling guidance
        - Infrastructure best practices

• Share a formalized list of recommendations for database performance enhancements and associated architecture diagram

• Initial remediation of prioritized recommendations