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