Open POP
Introducing SQL Quality and Performance Management Solutions
Ensuring stable performance through preemptive failure prevention of the operational DB
Through distribution control through thorough performance verification, SQL was managed without operating system failure, and the DB performance that had slowed down after the next-generation system was controlled through OpenPop's proven index strategy. It was evaluated as a wise choice to kill two birds with one stone: performance and stability.
The solution
Performance verification before deployment
Verify the performance of new SQL within the program requested by the developer in conjunction with the distribution system.
Performance change tracking management
Track and manage performance changes of newly deployed SQLs to improve performance degradation tracking of SQLs
Manage automatic indexing
Automatically analyzes Access Path through OpenPop automatic indexing management and implements index optimization by checking all operational DB SQL collected over 5 months
Performance Optimization Support Management
Process and history management of tuning work for SQL that is not performing well during deployment or has poor performance after deployment