Consulting
Diagnostic Improvement Services
Diagnostic Improvement Services
Diagnostic Improvement Services
DB/SQL comprehensive diagnosis and improvement service
This service is applicable regardless of whether you purchase OpenPOP. It uses OpenPOP's <Comprehensive Diagnosis> function to diagnose and analyze the DB status, operational SQL performance, and failure-causing factors for operational DBs that are experiencing service delays or are at risk of failure due to excessive workload of the operational DB, and supports improvements based on the results.
Collect Operational Data
Collects operational data from target databases.
DB & SQL Inspection
Inspects DB health, SQL quality, and performance based on operational data
Diagnosis & Analysis
Analyzes issues and identifies potential root causes from inspection results
Reporting
Delivers summary reports for key areas, prioritized by urgency
Performance Tuning & Guidance
Provides performance tuning services and optimization guides for target SQL
Diagnostic target DB and diagnostic area
DB with high workload and frequent performance load among operational DB servers
DB where service quality is likely to deteriorate due to delays in APP response time
SQL statement quality
Inspects whether an executed SQL statement contains potential risks that could lead to performance degradation or system failures
SQL Performance
Analyzes SQL-related issues that can lead to database failures, including inefficient queries, plan changes, and excessive temp usage
DB operation status
Proactive inspection of database configuration and operational health to identify and diagnose potential failure factors
Service Configuration
OpenPOP installation-based service
-
For customers who have purchased OpenPOP
-
For clients requiring continuous support for DB/SQL inspection, diagnosis, and improvement
-
Enables precise and comprehensive diagnostics using the rich data collected by OpenPOP
-
Combines OpenPOP's built-in diagnostics with hands-on optimization support from our experts
-
Drives performance improvements using OpenPOP's features for managing optimization processes, performance tracking, and history
-
Provides detailed diagnostic and performance improvement reports
OpenPOP Diagnostics Service
-
For customers who have not purchased OpenPOP
-
For clients requiring periodic diagnosis and optimization of their operational database performance
-
Quick and streamlined diagnostics
-
Diagnosis by OpenPOP's standalone program, with optimization support from our experts
-
Provides detailed diagnostic and performance improvement reports
Service environment
DB server operating system
HP-UX, IBM AIX, Unix 64 Bit
Java 1.6 or later
ORACLE DBMS
Version: Enterprise 11gR2 or later
Diagnostic Pack/Tuning Pack
