Our Services
Diagnostic Improvement Services

Diagnostic Improvement Services

Diagnostic Improvement Services
DB/SQL comprehensive diagnosis and improvement service
This service is applicable regardless of whether you purchase OpenPop. It uses OpenPop's <Comprehensive Diagnosis> function to diagnose and analyze the DB status, operational SQL performance, and failure-causing factors for operational DBs that are experiencing service delays or are at risk of failure due to excessive workload of the operational DB, and supports improvements based on the results.


DB Operation Data Collection
Operation of the diagnostic target DB
Data collection


DB/SQL Check
Check the DB status, SQL statement quality and performance, etc. based on DB operation data.


Diagnosis/Analysis
Problems and malfunctions found as a result of the inspection
Identify and analyze expected factors


결과 보고서
Provides a summary of the results by key area in the Urgent Action/Action Needed/Confirmation Needed system


Performance Improvements and Guides
Provide guidance and perform performance improvement work on target SQL based on diagnosis/analysis results

Diagnostic target DB and diagnostic area
DB with high workload and frequent performance load among operational DB servers
DB where service quality is likely to deteriorate due to delays in APP response time
SQL statement quality

SQL statements in the execution SQL have poor performance and
Potential risk factors that may cause disability
Check if it contains
SQL Performance

Plan change, new malicious SQL, Temp
May cause DB failures such as overuse
Diagnosing different types of SQL
DB operation status

DB configuration and various operating statuses
Obstacles through preventive maintenance
Inspection/Diagnosis
서비스 구성

OPEN-POP installation-based service
Customers who purchased Open Pop
If you want regular inspection > diagnosis > improvement support for operational DB/SQL
Precise and diverse diagnosis of items is possible with abundant information collected through Open Pop.
Use of OpenPop's comprehensive diagnosis function and support for improvement by experts
Performance improvement through OpenPop's optimization process/performance/history management function
Diagnostic and Improvement Performance Report

OPEN-POP diagnostic program-based service
Customers who did not purchase Open Pop
When periodic diagnosis and improvement of operational DB performance is required
Easy and quick diagnosis
Diagnosis and expert improvement support through OpenPop's independent diagnostic program
Diagnostic and Improvement Performance Report
Service environment
DB server operating system
HP-UX, IBM AIX, Unix 64 Bit
Java 1.6 or later

ORACLE DBMS
Version: Enterprise 11gR2 or later
Diagnostic Pack/Tuning Pack
