- Centralized management of various database products is possible. - Even without database experience, it is easy to identify the presence of bottlenecks in database performance and to pinpoint slow SQL queries.
The "Database Performance Analyzer (DPA)" is a monitoring product that performs operational monitoring of databases. DPA has two features that are not found in other monitoring products. Strength 1: It can monitor various database products and managed instances in the cloud with a single product module. Monitored database products: - Oracle Database - SQL Server - SAP ASE (Sybase) - DB2 - MySQL - MariaDB - Percona - PostgreSQL - EDB Postgres Strength 2: DPA detects and notifies about slow SQL queries. DPA utilizes a machine learning feature called Anomaly Detection to learn the SQL being executed. Based on the learning results, DPA automatically detects performance degradation and notifies the user.
Inquire About This Product
basic information
**Features of DPA** - Unmatched variety of monitored database products and types of cloud-managed instances in database monitoring products. - DPA monitors, detects, and notifies the presence of bottlenecks in databases. - Easily identify slow SQL queries with simple operations that even a child can perform. - Centralized management through a browser-based management interface. - Standard features include Index Advisor, Query Advisor, and Table Tuning Advisor. - Agentless, so there is no impact on the production environment during deployment. - Displays all necessary information for investigating slow SQL (wait events, CPU, memory, disk IO, etc.). - Compatible with various database products, allowing continued use even if the database product changes during system upgrades. - Comprehensive reporting features, with the ability to notify report contents in conjunction with alerts. - Low cost despite high functionality. *For more detailed information, please refer to our website.* **DPA** https://cosol.jp/license/dpa/ **DPA Technical Information (DPA Tips)** https://cosol.jp/knowledge/dpa-tips/
Price information
License type: Subscription license Contract period: 1 year Billing unit: Instance Price: Available at a low cost. Please contact us for details. Note: A volume discount is applied, where the unit price per instance decreases as the number of contracted instances increases.
Price range
P3
Delivery Time
P2
Applications/Examples of results
DPA is available for customers using various database products. - Customers using SQL Server - Customers using Oracle Database - Customers using SAP ASE (Sybase) - Customers using PostgreSQL
Detailed information
-
It is a group of database products and cloud-managed services (DBaaS) that can be centrally managed with DPA.
-
This is the DPA management screen (dashboard). It is a browser-based management console.
-
The machine learning feature Anomaly Detection learns the SQL workloads executed by the system. Based on the learning results, the DPA automatically detects performance degradation and notifies you.
-
The SQL statement is displayed along with related information necessary for investigation, such as wait events, blocking, CPU, memory resources, and cache. This makes it very easy to identify the factors that caused the SQL to be delayed.
-
The screen showing the anomalies indicated by Anomaly Detection will display the delayed SQL, making it easy for anyone to identify the delayed SQL.
-
Like other database monitoring products, DPA also allows for various alert notifications.
Line up（2）
| Model number | overview |
|---|---|
| Database Self-Hosted | This is the model number when using Oracle Database Enterprise Edition or Standard Edition, IBM Db2, SAP ASE (Sybase), SQL Server, MySQL, Percona, MariaDB, PostgreSQL, or EDB Postgres. |
| Database Self-Hosted for DBaaS | This is the model number when using Azure SQL Database. |
catalog（1）
Download All Catalogs
Company information
Our company consists of specialists who understand the field of database operations. We continue to provide services that contribute to the IT society as a partner that supports the system infrastructure of companies, solving challenges in database operations together with our customers. If you are responsible for the information systems department and have any issues or concerns regarding infrastructure centered around databases, please feel free to consult with us.