EXEM Consulting

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

  • Types of Service

    • DB Performance Improvement

  • Instance Performance Diagnosis

    • · 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
      System Diagram
      ERD blueprint

      • · Understand current business
           and IT infrastructure

      • · Collection of current issues
      • · Basic Training
      • · Detailed project plan
      • Project Schedule Definition
    • Analysis
      Tuning Request Program/SQL List
      Detailed program design

      • · 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
      Tuning target program trace Index configuration information

      • · 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, diagnosing the cause of database performance degradation and performing tuning is AS EASY AS ABC,
ensuring quantitative measurement of improvement effects.