MaxGauge for CloudDB is a database-specialized monitoring solution that can comprehensively manage cloud-based
commercial/open-source databases. Multiple databases can be monitored on one screen through 1-URL Platform integration,
and intuitive UI/UX enhances users’ convenience and supports operation and analysis focused on cross-linkage analysis.
It can be used in various cloud environments including AWS, Azure, OCI, and GCP.
Commercial/Open-source DBMS Integrated Monitoring
Various CSP Support
Architecture Suitable for
Cloud Environment
User-friendly Interface Providing Extreme Convenience
MaxGauge for CloudDB is designed to enable meaningful monitoring with minimal data according to the cloud environment.
MaxGauge for CloudDB allows DBAs to intensively monitor a single database while taking a closer look at multiple databases on one screen. OS & DB Metric, Latency (+TPS), Wait Class, Resource Usage, Wait Chains, and other SQL Summary information can be easily checked, which enables seamless database monitoring.
· Overveiw/DB Session Type/DB Wait Class/Time Model/
Resource Usage/DB Metric
Session and SQL-related metrics, plans, and full text that require detailed analysis are provided in a drill-down method. In addition, MaxGauge for CloudDB provides the trend of major monitoring indicators, the history of the past 1 minute, and the Kill Session function.
The ratio of key performance indicators by date gives users a very intuitive analysis. What’s more, through Daily-Time Ratio Bar, DBAs can select/deselect the information of the desired date and identify the cause of the load by checking the Top SQL of the selected date.
Through TOP-N trend analysis by section, the impact of the total or selected TOP SQL can also be confirmed. You can immediately check TOP-N data by Schema/Module/SQL when moving a section according to the search conditions, such as Group/Order by.
MaxGauge for CloudDB provides the number of SQLs changed in the plan and the trend over time. In addition, it is easy to check the plan change history, amount of work before/after the plan change (such as buffer gets, disk read), SQL Plan, and Reason information for the section. The Plan Diff feature allows you to compare two execution plans on one screen.
MaxGauge for CloudDB provides daily Wait Time status of the Wait Event (Class). By checking the Top Wait Event list for different dates, DBAs are able to confirm the SQL list where the Wait Event occurred.
Long-term trend analysis of specific SQL is provided. It also allows you to check information such as daily execution count and execution time, Graph/SQL Text in the STAT area. For example, I/O, etc.
Online Service
E-commerce System
As the use of Cloud DB increases, difficulties in performance monitoring and management gradually occur, and then we were trying to find a solution which can help us derive causes/analysis when bottlenecks arise.
• CPU usage reduction by SQL tuning through extraction of Top-SQL with high usage and derivation of Function in
problem section.
• Reducing I/O-related costs by transferring low-critical tasks to RDS by checking SQL with a high share of disk I/O
through the Top-N function.
• Transferring backup object data that is not used for operational tasks by deriving objects with high I/O-related indicators in a
specific time period.
• Cost savings of KRW 570,000 per day on average and KRW 17 million per month after the adoption of MaxGauge for CloudDB.