Speedgain for Databases

Add Option to import and export Monitoring configuration for Certificates, Logins, Policies, Nodes and Databases (but not Licence and Data retention settings!)

New x1F Look and Feel matching fusion of ITGAIN with x1F

PostgreSQL Startup timeout is set to 300 seconds because new default since TimeScaleDB 2.26.1 is to low (can be configured see documentation chapter 3)

added Change log to online documentation on https://speedgain.info

CVE fixes in all Speedgain components

Dashboards:

CVE fixes in all Speedgain components

Performance Database (s4dbs_postgres container): introduced several configuration switches to controll upgrade behavior, please see: https://speedgain.info/_docker_based_migration.html#_before_you_start_known_pdb_migration_issues_and_fixes_2

fixed restart issues of the Performance Database (s4dbs_postgres pod) on OpenShift environments

Multipod Collector

Enhanced Helm deployments (including PostgreSQL security context handling) and optimized Timescale image size.

Improved Db2 statement analytics with per-exec vs. total metrics, timeframe vs. since-start views (strict vs. extended), and extended cluster visibility.

Resolved critical PDB connection backlog issue and improved Linux Collector error handling.

Upgrade to Java 25, improved CI quality gates, and multiple UI & dashboard fixes.

MCP Server integration:

New Db2 dashboards for a Cluster view of Applications (DPF and pureScale)

More robust collector architecture with improved error handling and faster startup

Enhanced TimescaleDB migration and PostgreSQL 16 compatibility

Hardened REST API and automatic re-init of connection pools after repeated errors

Frontend usability improvements (dropdowns, bulk actions, menu navigation, client settings)

latest security fixes for all components

40+ enhancements and bugfixes compared to 2.0.0

New: Test connection for servers & databases, database login check

Collector: Smarter scheduling, better JDBC pooling, Java Virtual Threads

Dashboards: Enhancements within Db2, PostgreSQL and Self Monitoring - new metrics & structure

UI: Full JDBC/Prometheus URLs, better bulk actions, improved config UX

Security: Latest patches incl. Spring WebMVC CVE, token & license handling

Helm/K8s: Resource limits, health checks, reverse proxy options

PostgreSQL v16 & TimescaleDB 2.18.1 support and automatic migration

70+ enhancements and bugfixes compared to 1.8.2

Performance Enhancements

Multi-Select Actions on Configuration Page

Two New Collectors for Db2 PureScale:

Db2 Configuration Change Tracking

New Oracle Collectors and Dashboards:

Linux OS Collector with SSH Connection Pool

Exclusion of Offline SQL Server Databases from Collectors

Improved JDBC Parameter Handling

Latest Security Patches Integrated

REST API Documentation Available online

Upgrade java, tomcat, spring, grafana and dependencies to latest patches available

S4DBs configuration tabs are now sortable tables

Fixed license upload error message

Prometheus datasources can now be set back to „no-login“

Db2 Temp Usage Board: Added Info

Db2 Application Detail Board: added status chart

Added annotation switch on every dashboard, defaults to disable

Some minor dashboard enhancements

Updated Podman installation documentation

Fixed collector reconnect issue after timeout

Enhanced error messages for prometheus datasources

Fully documented rest-api via swagger (http://<yourSpeedgainServer>/Speedgain_for_Databases_Service/swagger-ui/index.html#/)

Removed licence part from kubernetes installations (now uploaded via frontend)

Support for MariaDB/MySQL (via Prometheus Exporter)

Support for MongoDB (via Prometheus Exporter)

Support for Generic DB (Any Prometheus Scrape Source)

Grafana V10 - New Design and New Alerting Engine

Vue.js Frontend Update

Faster Config Load for huge config in small environment

Service and UI tomcat base image upgrade

collector fedora base image upgrade

Update Java dependancies

Webtoken encryption improvements

small bugfixes

Support for Azure SQL Database

Support for Oracle Database

New Linux Collector and dashboard for Filesystem Usage

Db2 Cluster SQL Statement Analysis dashboard added

Db2 PureScale Member Page Access Collector and dashboard added

SQL Workbench enhancements (Db2 only)

SQL Server Blocking Analysis dashboards added

SQL Server dashboards for waits analysis improved

New Collector Status dashboard

Stability improvements in the backend

More prefetching information on several Db2 dashboards

Licence upload via frontend

Reduced memory footprint in collector backend during startup

More built-in default policies

Minor dashboard enhancements for Db2 and SQL Server

New data source filter on overview dashboards for Db2, PostgreSQL, SQL Server, and Linux

Minor SQL Server bugfixes

Adjusted the default policy for SQL Server changing collection interval and default-wise enabled Dynamic Managed Views (DMV)

Optimization of SQL Server collector dm_exec_query_stats

Alert for collector in status error now uses the display name for the data source

Fixed potential Collector hanging while startup

Database check and logging behavior of the Collector improved

Introducing Db2 PureScale monitoring support

Several dashboards for Db2 PureScale and Db2 DPF added

Db2 instance Info Collector added

Db2 Instance Info dashboard added

Db2 Temp Usage dashboard added

Introducing SQL Workbench for Db2

General support for Red Hat OpenShift and Kubernetes

Added frontend option to auto configure REST-Service and Grafana host address for OpenShift and Kubernetes environments

Improved internal database error handling

Restricted removal of nodes related to a database, which is monitored

Fixed missing informations in the status view occurring if a database is monitored on a node without provided credentials

Changing the instance name will now be recognized as a configuration-change.

Added SQL Server collectors for backup, indexes, query stats, sessions und session wait stats

SQL Server Backup dashboard added

SQL Server Configuration dashboard added

SQL Server Index - High Impact Missing Indexes dashboard added

SQL Server Index - Missing Indexes - Details dashboard added

SQL Server Index - Usage - Details dashboard added

SQL Server Index - Unused dashboard added

SQL Server Live dashboard added

SQL Server Query - Usage Analysis dashboard added

SQL Server Query - Details dashboard added

SQL Server Query - Plan / SQL Statement - Details dashboard added

SQL Server TempDB dashboard added

PostgreSQL Workload Dashboard Re-Design

Minor Db2 Dashboard bugfixes

Db2 mon_get_connection collector now collects new db2 v11.5.8 data

Db2 SQL Statements Inflight now has a drill down for more details and trendcharts

Speedgain Login now only needed when accessing sensitive area

Policy Editor new table design for collector configuration

Added SQL Server collectors for databases, file space usage, virtual file stats, performance counters, wait stats, cpu, and configurations

SQL Server Overview dashboard added

SQL Server Used Space by Database dashboard added

SQL Server Database Total Size and Growth dashboard added

SQL Server IO Statistics by Database dashboard added

SQL Server IO Statistics by Volume dashboard added

SQL Server Memory dashboard added

SQL Server Generic Performance Counter dashboard added

SQL Server Activity Overview dashboard added

SQL Server Waits Overview dashboard added

SQL Server Top Waits by Wait Type dashboard added

SQL Server Wait Time Details dashboard added

SQL Server Workload Group Statistics dashboard added

Added SQL Server alarms for CPU, Memory, Buffer Cache High Turnover, volume free space, data file free space, and log file free space

Added Nginx Reverse proxy

Added /s4dbs_custom_boards to grafana container to provision custom dashboards (see https://github.com/ITGAIN/s4dbs_custom_boards)

switched lookups to display names from e.g. host:port/db-name

redesigned internal table design to a view based one

Option to set custom JDBC parameters for monitored databases

Option to set retry intervall for collectors

Redesigned Collector Status Page with option to start and stop collectors

More detailed Login error messages

New upload function for key stores

Changed from "server" to node on configuration page

Fixed setting wrong user password on user update without changing password

Linux Collector fix when custom ssh welcome messages are used

Db2 Overview enhanced

Db2 Workload added direct read and write and more drill down links

Db2 App Details enhanced

Db2 IO added IO timing per second

Db2 Tablespace counter for not normal state tbsp added

Db2 Applications last state added

Db2 Tables Custom Column option

Db2 Latch Contention Collector

Db2 Latchwait Dashboard enhanced by latch contentions

Db2 Index Dashboard added

Db2 DPF compatibility (member can now be selected on every Db2 Dashboard)

Added OS disk throughput Dashboard

Fixed some minor bugs on db2 Dashboards

Enhanced performance for some Dashboards

Redesigned S4DBs Hypertable Dashboard

added alerts for failed internal jobs and collector status error

Db2 Sort Dashboard

Db2 Lock Event Collector & Dashboards

Db2 Workload Manager Collector & Dashboards

Db2 Utilities Collector & Dashboard

Db2 HADR Collector and Dashboard

Db2 Live Dashboard

Added around 60 Drill Down Links on Db2 Workload Dashboard

Enhanced Db2 Transaction Log Dashboard

Renamed some Dasboards to be clearer (IDs still the same - links are still working)

Improved Performance on S4DBs Overview

Fixed smaller Bugs on some Db2 and PostgreSQL Dashboards

Copy as New in Configuration Area

Improved Menu in Speedgain for Databases

Improvements in Backend-Collector Code

Failed Collectors can be restarted via disable → wait 60s → enable

change password via web frontend

added add database wizard

enhanced auto logoff timer

Db2 SQL Analysis Dashboard

Db2 STMTID Dashboard

enhanced Db2 Single SQL Detail Dashboard

enhanced PostgreSQL Workload Dashboard

Db2 Size Distribution Dashboard

Db2 Memory Pools Dashboard

Db2 Inflight SQL Statements Dashboard and Info on Application Detail Dashboard

Db2 Tables Dashboard

Db2 Routines Dashboard

Db2 Latchwait Dashboard

added num executions or time as basis for KPI calculation on some panels

enhanced Db2 Application Throughput Dashboard

Db2 Lockwait - Event Detail Dashboard (available from Lockwait Dashboard)

enhanced Db2 Workload Dashboard

PostgreSQL - added links between Statements and Application List

PostgreSQL - WAL Dashoard

PostgreSQL - Tablespaces Dashboard

PostgreSQL - Configuration Dashboard

Db2 SQL Statements Dashboard

Db2 SQL Statement Detail Dashboard (available when clicking on a SQL statement)

DB2 IO Dashboard

PostgreSQL SQL Statements Dashboard

PostgreSQL SQL Statement Detail Dashboard (available when clicking on a SQL statement)

PostgreSQL Application List now shows last Query

PostgreSQL Apllication List Detail Dashboard for Single Application (available when clicking on a PID)

PostgeSQL Lockwait - PIDs are now clickable and guide you application list filtered by that PID

Alarm Dashboard

Alarm Overview on overview (this Dashboard)

Pie Chart is back

Repository size panel on overview (this Dashboard)

Dashboard list panels on overviews replaced by Dashboard Menu

minor panel enhancements

grafana 7.2.1

mouseover tooltip activated

minor bug fixes

Menu moved to Grafana

Overall Overview Dashboard (this)

Enhanced Dark/Light Switch

New Db2 Collectors and Dashboards

PG Monitoring Added

OS Monitoring Added

Enhanced Backend Collectors