EXEM

Inverstor Relations

Consulting

Database Performance
Diagnosis Consulting Service

Start your consulting service with Korea’s top-notch professional consultants who have many years of consulting experience in the database tuning industry. Using MaxGauge, the No. 1 performance management solution in Korea, we present a guide on real-time monitoring and tuning for database and ERP systems, and execute premium performance diagnosis through log analysis of collected system history.

  • Accuracy of Peak Time Analysis
  • Reliability of
    SQL Tuning
  • Operational Stability
  • · Systematization of performance management methodology through years of consulting experience
  • · Quickly and clearly diagnose the cause of failure in the database
  • · Optimization service through premium performance diagnosis consulting
  • · Reliable performance diagnosis and improvement service

Benefits of Consulting

When it comes to stable system operation, prior problem recognition and prevention are necessary to align with rapidly changing service requirements.
The key to maintaining the best performance is checking for problems in the current system's operation and suggesting/applying improvement measures. EXEM aims to increase customer satisfaction with IT services by presenting high-level diagnosis and improvement plans for maintaining high-availability systems.

  • Maximization of
    disability
    prevention effect

  • Tangible effect of
    performance
    improvement

  • Building a stable
    operating
    environment

Consulting Services

Instance
Performance
Diagnosis
(system level)
· Initialization parameter
· Key performance indicators
· Major waiting events
· Bottleneck analysis
· Oracle Alert log
· Threshold setting
System
Resource
Usage
Analysis
· I/O analysis of datafiles
· Composition of Tablespace,
  Table, Index objects
· Partitioning CPU usage
· Memory usage
· Swapping, paging phenomenon
· Semaphore setting parameter
· N/W performance
· Disk I/O performance
RAC
Performance
Diagnosis
· Load balancing
· Initialization parameter
· Contention
· Key performance indicators
· Major waiting events
· Efficiency of background processes
AP
Performance
Improvement
· Selected APs and SQL
· Inefficient SQL
· Contending SQL
· Linkage with WAS
· Data modeling
Storage
Configuration
Check
· I/O analysis of datafiles
· Composition of Tablespace,
  Table, Index objects
· Partitioning
DB Operation/
Management
Check
· User authority/password
· Statistical information policy
· Key performance indicator
  threshold setting
· Inefficient SQL pattern check and guide
Education · Oracle architecture
· SQL Tuning
· OWI wait event analysis
· Technical issues

Consulting Process

  • Initiation

    · Understand current business and IT infrastructure
    · Collection of current issues
    · Basic Training
    · Detailed project plan
    • · Project Schedule Definition

    Analysis

    · Interview with person in charge/developer/system operator
    · Verification of current model and physical design
    · Tuning target (program/SQL selection)
    · DB Operational Health Diagnosis (PMA)
    • · DB Diagnostic Report

    Execution

    · Program/SQL performance tuning
    · Resolve DB operational issues
    · Apply and measure application improvements
    • · Program/SQL Tuning Advice
    • · List of DB Issues and Operation Plan

    Assessment
    /Closure

    · Acquisition of technical information
    · Final report
    • · Project Final Report
    • · Educational Materials

With MaxGauge, diagnosis and tuning is
as easy as ABC!

Inquiry

captcha image

Thank you for your contact
and we will reach out to you soon!