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 성능변화 & 영향도 분석 솔루션

DB 운영환경 변화 또는 DB 오브젝트가 변경되면
SQL 성능에 어떤 변화가 있을까?
OpenPOP SPS가 신속하고 명쾌한 답을 드립니다.

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



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.
SPS

SQL Performance Change Simulation
When the DB operating environment changes, all related SQLs
To understand the change in performance between AS-IS and TO-BE
After automatically performing the simulation, the performance of each SQL
We analyze and provide information on changes.
01

Performance Optimization Management and Support
Simulation results on performance changes in SQL,
About SQL that needs performance improvement
Effective performance optimization work
It provides various functions to enable progress.
02
STRENGTHS
OpenPOP SPS has these strengths:







PROCESS
SPS는 운영 DB 환경의 변화로 인해 발생될 수 있는 SQL의 성능장애를 예방하기 위해,
관련 SQL에 대한 성능변화 검증기능을 아래의 Process로 자동화하여 신속한 검증을 가능하게 해줍니다.


FUNCTION
SQL 수집
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.


SPS operating environment



OpenPOP SPS is
This is necessary in these cases

Oracle Upgrade

U2L & Cloud Migration

Change DB parameters
