Continual assessment of database performance

External database performance from the application point of view is continually assessed and visualized.

The application performance is only influenced when this indicator worsens.

The DBA can quickly assess whether the application is compromised or not with this indicator.

From problem to cause in one click

The exclusion principle:

• Identification of the bottleneck resource
• Which resource is being used with which compartment (CPU, IO, LOG, etc.)?

The trigger principle:

• Which application or SQL is causing which section in the total consumption of the bottleneck to use up resources?

Flexible expansion of monitoring through the module plugin process

New functionalities can be expanded dynamically in Speedgain though the module plugin process. That makes, e.g., integration of your own monitoring scripts possible.

Analyze access paths using Speedgain SQL Workbench SQL

The Speedgain SQL Workbench recognizes and corrects performance problems from individual statements. It can be implemented independent of the Speedgain Repository and is consequently an important means of support in the DB2 application development.

The status monitor shows the current status of all servers and databases on one page

Server operation system information:

• CPU and IO usage directly delivered from operating system
• SWAP area and information about blocked processes

ProzesseDatenbank Informationen:

• Load information (logical and physical read access)
• Database time distribution – which resources are using database time

The Speedgain Cockpit offers a quick overview of the database activity and resource usage.

Workload – show activities in the database. Rows read as well as logical and physical reads are displayed, among others.
Application states – shows the status of the applications Distribution – shows the distribution of usage times on the resources such as CPU, I/O time, or sort time.
PDB High Watermark – shows current usage in relation to absolute maximum usage measured.

Identification of "locust swarm"

Identification of allegedly “small” SQL statements that negatively affect the system performance by being carried out frequently.

Switching between the individual SQL statements and an aggregated display is possible in one click.

OS monitoring provides the operating system indicators necessary for an overall picture

Display of correlated operating system and database performance metrics, preparation of server performance indicators for causal analysis

• Number of interrupts and context switches
• CPU load
• Storage usage
• SWAP area usage
• Detailed I/O information

Predefined and configurable reports offer numerous evaluation options

Expanded performance analysis though the use of predefined reports, which can be configured easily:

• Provides insight into hidden and slow developing problem
• Display of resource usage
• Visualization and analysis of performance metrics within configurable time frames
• Growing number of reports

Identify the main users of resources with the ABC analysis

The ABC analysis divides objects into three classes. It is a method of identifying, separating, and prioritizing critical objects.

Division of classes:
Class A – 80% – Class B – 15% Class C – 5%

This enables a focus on the most important triggers and, therefore, enables efficient analysis.

The evaluation of the db2diag.log provides information on performance and availability

With the help of the navigation function, it is possible to check a whole time period, not just a single point, within a list view.

This make interesting log entries, which could be problematic, easier to read and more obvious.

Numerous filters make effective evaluation possible.