MaxGauge

The Standard Database Performance Management Solution in Korea

As a professional solution for database performance management, MaxGauge is specialized in efficiently managing the availability
and performance of database systems. By providing Pro-Active monitoring techniques, it quickly recognizes problem situations
and effectively analyzes application bottlenecks to provide clear and accurate analysis data.

No.1 Solution in Database
Performance Management
No.1 Market Share
in Financial Sector
Delivered to
800 Large Customers
Global Contracts with
Clients Over 29 Countries

Features

MaxGauge provides a very detailed analysis of bottlenecks detected through real-time monitoring.
What’s more, it is designed to collect and monitor all performance data with minimal load.

Real-time Monitoring

Real-time monitoring of various performance indicators
Direct Memory Access

Provide monitoring and analysis even when the database is experiencing downtime or hanging situations
Data Collection in 0.01 Second

Precise analysis by collecting data as in real time and saving it in 1 second unit
Smart Analysis

Automatic detection and reporting/mailing function provided when performance deterioration occurs
Alarm/SMS Connection

Provide alert setting for all performance indicators, and SMS/Mail connection
User Management

Setting for accessible IP range,
DB list, user permission
DB Performance Report

Provide user-friendly daily/
periodic indicator reports
Support for Various DBMS
and Cloud Environments

Support for both commercial and open-source
DBMS across various cloud platforms,
including AWS, Azure, OCI, and GCP.

Monitoring Views

Session Monitoring

Real-time session information is provided as a list, and detailed information can be checked simply by a mouse click. Database wait status and session intensive monitoring are also helpful to DBAs

· Grouping Active Session/Lock Waiting Session by time unit
· Provide performance information on Parallel Query
in a tree structure of Coordinator and Slave sessions

RAC Monitoring

RAC View is a monitoring screen dedicated to RAC, and you can easily grasp information on Global Lock, Load Balance, and Network usage.

· Global Lock: Real-time check when lock occurs on RAC and
   provide lock tree linkage.
· RAC View: Check Active Sessions information simultaneously on
   one screen
· Load Balance: Balance check by indicators between RAC nodes
   and they can be easily changed.
· Provide monitoring of OS, memory information and network packet
   amount between RAC interconnects.

Resource Monitoring

CPU and Memory information of all database servers being monitored are provided in three forms: Multi/Group/Single.

· Provide trend for total waiting time by instance and waiting time by
   event
· Easy check for top process list of the server through Process
   Monitor
· Provide Oracle SID information of processes used by Oracle and
   can be linked with Session Detail

Lock Monitoring

Provide the number of sessions grouped by lock waiting time range and the relationship between lock holder and waiter in a tree structure.

· Provide Global Lock information in the case of RAC/TAC
· Lock related alarm is provided by setting lock occurrence time

SQL Monitoring

SQL Elapsed Time displays the SQL execution time per instance as a dot and each dot represents the completion of SQL execution. In addition, by linking with Full SQL Text, the Top-10 SQL list by performance (Elapsed Time, Buffer Gets, Disk Reads) of the instance being monitored and the corresponding SQL information are provided.

· Provide individual SQL execution history, SQL Full Text, SQL Plan,
Bind information, etc.
· Drag SQL Elapsed Time chart -> Select/Click SQL List -> Check
SQL Detail information

Analysis Views

Summary View

Provide hourly average trend graphs on a daily basis for key performance indicators and waiting classes, so that peak times can be easily identified.

· Check Top Schema, Program, Module, and SQL for different time
periods on a day
· Check Executed Top-N data and SQL execution per waiting event
for different time periods.

Performance Trend

As one of MaxGauge’s representative analysis screens, performance trend allows users to precisely analyze diverse troubles while enabling trend analysis of DB performance indicators, waiting events, and waiting classes.

· Active session analysis with one-second logging interval
· Active session statistical analysis with one-minute/hour logging
interval
· Top O/S Process analysis with one-minute logging interval
· Lock Tree Analysis
· PQ Tree analysis
· Peak section statistical analysis

Top-SQL Comparison

MaxGauge provides a Ranking View according to changes in SQL workload by selecting the date to be compared with the standard date. If you select a specific SQL, you can check the daily ranking change and SQL performance information (Elapsed Time, CPU Time, Wait Time, Logical Reads, Physical Reads) at the same time.

· Comparison and analysis of Top SQL targets compared to the base
date by 1:M, N:M
· Provided long-term trend analysis in connection with the
Long-Term Trend function

Plan Change History

The number of performance degradation and improved SQL cases due to SQL execution plan change can be checked with ease through SQL Plan Change History and Analysis.

· Comparison of SQL Plan change history and execution time by
   date: Red represents the number of slow response times/Green
   represents the number of fast response times
· SQL Plan Diff function: Compare two SQL execution plans and
   provide information before/after SQL plan change for a specific
   SQL

DataPath View

Provide weight analysis for multiple instances or multiple dates and bi-directional linkage analysis between instances, schemas, programs, modules, and SQL.

· Flow Visualization technique is provided as data visualization
· Instance/Schema/Program/SQL can be compared visually and
easily
· Possible to analyze the relationship between different data

Architecture

Supported Database

Customer Cases

Electrical

Transmission and Substation System

Adoption Background

Necessity for checking and improving DB status due to system aging and continuous service increase, that’s why we need to check and improve DB status.

Benefits

• Improving response speed through pre-detection of troubles in critical core systems, reducing system downtime and
failover time.

• Reducing CPU utilization by more than 30% through extracting Top SQL for a specific period.

• Reducing more than 90% of waiting event occurrence time in specific time zone.

• Helped clients save about KRW 1.41 billion 5 years after adopting the solution.
Public

Transportation Management System

Adoption Background

Performance analysis and improvement are urgently needed due to continuous service delays and increasing complaints from customers.

Benefits

• Check periodic lock occurrence status through real-time monitoring and take immediate action and analysis.

• Resolve lock occurrence by changing batch operation logic and execution time.

• In terms of performance management, MaxGauge provides more information than what we were looking for without
putting a load on the system.