top of page

Our Services

Diagnostic Improvement Services

sub-visual02.jpg

Diagnostic Improvement Services

sub-visual02.png

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/SQL comprehensive diagnosis and improvement service
DB/SQL 종합 진단 및 개선 서비스

DB Operation Data Collection

Operation of the diagnostic target DB

Data collection

DB/SQL comprehensive diagnosis and improvement service
DB/SQL comprehensive diagnosis and improvement service

DB/SQL Check

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

DB/SQL comprehensive diagnosis and improvement service
DB/SQL comprehensive diagnosis and improvement service

Diagnosis/Analysis

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

DB/SQL comprehensive diagnosis and improvement service
DB/SQL comprehensive diagnosis and improvement service

결과 보고서

Provides a summary of the results by key area in the Urgent Action/Action Needed/Confirmation Needed system

DB/SQL comprehensive diagnosis and improvement service
DB/SQL comprehensive diagnosis and improvement service

Performance Improvements and Guides

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

bg-diagnosis.jpg

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
DB/SQL comprehensive diagnosis and improvement service

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

SQL Performance
DB/SQL comprehensive diagnosis and improvement service

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

DB operation status
DB/SQL comprehensive diagnosis and improvement service

DB configuration and various operating statuses
Obstacles through preventive maintenance
Inspection/Diagnosis

서비스 구성

DB/SQL comprehensive diagnosis and improvement service
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

DB/SQL comprehensive diagnosis and improvement service
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
DB/SQL comprehensive diagnosis and improvement service
ORACLE DBMS
  • Version: Enterprise 11gR2 or later
  • Diagnostic Pack/Tuning Pack
DB/SQL comprehensive diagnosis and improvement service
bottom of page