Solution
When the DB operating environment and operating platform change, you can identify problems that may occur due to SQL performance degradation in advance and respond to them early.
SQL Performance Change & Impact Analysis Solution
When the DB operating environment changes or DB objects are changed
What changes will there be in SQL performance?
OpenPOP SPS provides quick and clear answers.
When the DB operating environment and operating platform change,
This may be caused by poor performance of SQL.
Identify problems in advance
can be dealt with early
SQL Performance Change Simulation
To assess the impact of changes in the database environment, the system automatically simulates performance shifts between the AS-IS and TO-BE states for all relevant SQL, providing a detailed analysis for each query
01
Performance Optimization Management and Support
The system offers various features to facilitate effective performance optimization for SQL identified as needing improvement through simulation results
02
When the operating DB environment changes,
It quickly analyzes changes in the performance of related SQL (performance degradation) and provides the results, and provides various functions necessary for taking action to prevent DB/SQL performance failures that may occur after changes in the DB operating environment.
STRENGTHS
OpenPOP SPS has these strengths:
SQL collected from AS-IS DB
Automatically run in TO-BE DB environment
SQL that causes errors and performance degradation Extracts quickly.
Due to plan change in TO-BE DB
When SQL performance deteriorates, AS-IS is optimal Apply profiles automatically.
Performance verification in a TO-BE environment
Applying various Bind values and repeatedly executing SQL
Get objective performance information through options.
Through full analysis of SQL's Access Path
After configuring the optimal index, the performance improvement effect
It guides you to the optimal index that is verified.
In the process of analyzing SQL performance changes
Performance tuned SQL is also repetitive
Performance revalidation is possible.
In the initial stages of stabilizing TO-BE DB operation
For performance changes in all running SQLs Tracking is possible.
PROCESS
SPS is designed to prevent SQL performance problems that may occur due to changes in the operating DB environment.
The performance change verification function for related SQL is automated with the process below to enable quick verification.
FUNCTION
Comprehensive DB performance comparison
SQL collection
Performance Comparison/Analysis
SQL Performance Optimization
SQL collection
Operational DB SQL Collection
You can set SQL collection targets, collection periods, collection SQL conditions, etc. to collect only the necessary SQL information from the DB for a set period of time.
Comprehensive DB performance comparison
Comprehensive DB performance comparison/analysis
In the TO-BE DB operation stabilization stage, you can comprehensively compare/analyze the AS-IS DB performance, the performance in the verification stage, and the performance in the current DB in operation, and track/analyze the change trend of SQL performance in the TO-BE operation DB for a certain period of time.
Additionally, it provides various support functions so that preemptive measures can be taken through early notification for SQLs that may cause failures due to performance degradation.
Performance Comparison/Analysis
SQL execution performance comparison/analysis
In a TO-BE DB environment, all collected SQLs from AS-IS are automatically executed to check for errors and compare/analyze SQL execution performance between AS-IS/TO-BE.
At runtime, you can secure the objective performance of SQL by applying N bind values and setting various execution options.
By selecting multiple execution conditions, users can also compare/verify performance only for a limited range of SQLs they want.
SQL Performance Optimization
Optimizing SQL execution performance
After comparing/analyzing AS-IS/TO-BE SQL execution performance, the current optimal Profile is automatically applied to SQLs with degraded performance due to changes in SQL PLAN.
It supports functions to improve performance right away, and provides index optimization guide through full analysis of SQL in TO-BE DB environment.
You can effectively improve DB/SQL performance optimization by reinforcing the deficiencies of the current DB index.
SQL collection
Performance Comparison/Analysis
SQL Performance Optimization
Comprehensive DB performance comparison
SPS operating environment
OpenPOP SPS is needed in the following cases
Oracle Upgrade
U2L & Cloud Migration
Change DB parameters
