SPEEDGAIN FOR BIGSQL
Monitoring the SQL Execution of BIG SQL (SQL Monitoring)
The Big SQL workload is logged in detail. The resource costs as well as the internal processing order of SQLs are documented.
Monitoring the MPP Architecture of a Hadoop Cluster
The Performance characteristics of individual DataNodes (Workers) and their intercommunication is monitored and logged.
Long-term performance monitoring also for Big SQL scenarios
During a causal analysis in the database area, all necessary historical information from the database server is made available. This enables a retroactive and complete analysis of specific problem and leads to improved database service quality.
Big SQL workload analysis
As a basis for optimization in accordance with use, the Big SQL workload available in the database is evaluated and filed optimally for analysis purposes. The user is provided with means to analyze the aggregated Big SQL behavior.
Monitoring of Big SQL and SQL
The analysis can be carried out as with related databases and does not require a lengthy training.
Supports all monitoring functions in the same way as a classic SQL monitoring
The Speedgain Cockpit provides a quick overview of database activity and resource usage.
Monitoring of %CPU and %Memory with Big SQL
A complete picture is provided. Often, pure database monitoring is not enough for analysis.
Integration with your DB2 monitoring
You can monitor queries against DB2 native and on Hadoop via Big SQL in a consolidated interface. Having a separate Hadoop monitoring is not necessary.
