This refers to the task of checking SQL quality with the following functions.
Provide developers with opportunities to check and improve SQL quality during the development process
Automated real-time quality checks for all SQLs in development phase
Providing status of SQL quality check (by DB/by task/by developer)
You can check/verify SQL performance with the following features:
Provides developers with opportunities to check and improve SQL performance during the development process
Automatically extracts target SQL for tuning by constantly checking development/operation SQL
Batch automatic performance verification for developed SQLs
Pre-control of quality and performance non-conformance SQL operation transfer/distribution
It means automatically designing indexes by analyzing the Access Path for the entire SQL and recommending the optimal index for each table to improve DB/SQL performance through SQL analysis and operational index analysis.
It provides the following features:
Real-time alerts on DB operation failure-causing factors and automated daily checks of DB status and SQL performance
Comprehensive diagnosis of periodic operational DB status and SQL performance/quality (failure-causing factors)
Real-time detection and rapid action for SQLs whose performance deteriorates rapidly due to changes in execution plans
Diagnosis and analysis of DB objects and SPACEs
Automated extraction of performance-degrading SQL (tuning targets) and in-depth performance analysis of Module & SQL
Tracking/analyzing initial performance changes of newly introduced (applied) SQL in operation
Analysis of the impact of SQL performance changes when operating DB objects change or DB operating environment (platform) changes.
This means that it supports early judgment and optimization of SQL plan changes when updating DB statistics.
You can manage the progress and performance of tuning for all SQLs targeted for performance improvement, as well as the tuning history for SQLs targeted for performance improvement.
Support
오픈메이드컨설팅의 OpenPOP 솔루션 패밀리 관련 FAQ를 통해 많은 고객이 어떤 것을 주로 질문하는지 확인해 보세요.
