Blog

See the future – reproduce and planning your workload

1. Find the optimal setup – like a formular 1 racing car (DB2 Database) for a certain racetrack (workload)
2. Simulate your business – increase the number of costumers (DB2 Connection)
3. Test and evaluate alternatives – MPP versus SMP, BLU versus nonBLU, AIX versus LINUX, DB2 versus Postgres
4. Minimize your risks – for example if you move into the cloud
5. Save money

“To certify new server infrastructure or any significant changes
we use the SQL-Replayer from ITGAIN to reproduce our specific
workload.“

Erik Bak-Mikkelsen,
Head of Cloud Operations, Moovel (car2go a subsidary of Daimler)

Highlight – With SQL Workload Analytics one can analyze the complete SQL workload of a database for configurable time interval

Further Enhancements

1. Extended portable version
2. Speedgain now includes SAP Crystal Reports to improve the analysis of the performance data. This supports both Speedgain predefined reports as well as individual reports.
3. Monitoring of operation on column organized tables is now supported
4. New Speedgain Modules to monitor
5. DB2 Threads
6. Latches in DB2
7. Presentation of the tablespace states with filters
8. Additional filters enhance the clarity of the Status Monitor
9. Improved storage of tablespace and filesystem information to reduce the memory footprint

SQL Workload Analytics – Integrated TOP N Reporting

The new version enables the complete possibilities to analyze the whole SQL workload.

With older version it was only possible to analyze the SQL Workload for the last snapshot.

With the new version it is possible to analyze the SQL Workload for any time interval like one hour, one day or one week.

The new version make it possible to export the analyzed SQL Workload for further processing.

SQL Workload Analytics – Analyze aggregated workload behavior

Combining the existing Normalization feature with the SQL Workload Analytics one can analyze aggregated SQL workload behavior for user-defined time periods.

The Normalization feature automatically groups similar statements into one statement group. With this the „locust swarm“ of small SQL statements can be recognized and the creation of indexes is much more efficient.

Predefined and custom reports are available

Use predefined reports… There are delivered some reports that provide information on different topics.
… or create individual ones You can easily create your own reports. Use SAP Crystal Reports to design your report (the *.rpt file) and execute it from within Speedgain. Please note that the SAP Crystal Report Designer is NOT included in Speedgain for DB2.

Monitoring of Operations on Column Organized Tables

Observe the buffer pool utilization for column based access. The DB2 BLU feature is now supported. Activate the Bufferpool module on the instance settings page.

New module “Latch Monitor”

Latches Overview – DB2 latches, the traffic lights of the internal DB2 guidelines, are monitored by the new version of Speedgain. Their holders and the number of waiters are visualized. This makes it possible to detect lock situations within the database which are not found with conventional lock-chains. Latch Link to the holders – It is possible to link to the holders of the Latches

Tablespace States are added in the overview

Find abnormal tablespace statesA new column in the Tablespace List shows the states (there can be more than one) of each tablespace. Tablespaces with normal state can be excluded from the result.

DB2 Version 9.5 is no longer supported for PDBs

DB2 9.5 is no longer used by most of our clients. Only for legacy applications, it is still in use occasionally. To use recent features of DB2, Version 9.5 is no longer supported for the Speedgain Performance Database. However Speedgain V4.8 is still able to monitor DB2 8.2 and subsequent.

Please contact the Speedgain support if you are using 9.5 for your PDB and cannot migrate.