Released: Apr 15, 2025

Updates in April 2025

Funktionen

• Postgres
  • Job "Database status":
    • Monitors availability via datallowconn in pg_database.
    • Supported with dbWatch engine installed.
  • Job "Database status alert":
    • Monitors availability via datallowconn in pg_database.
    • Supported without dbWatch engine installed (no dbWatch schema).
• MS SQL Server
  • Job "MS SQL Server patch status": Added patch info from Microsoft Update Catalog up to March 2025 (CU18 for 2022, CU32 for 2019, SP Azure for 2017).

Improvements:

• MS SQL Server
  • Improved several menus and enhanced usability in the Audit section of the Management module.
• Farm views
  • Significantly improved the Farm View for Maintenance jobs: better structure, clearer output, and enhanced documentation.
• Postgres
  • Now supports PostgreSQL version 17.
  • Job "Transaction statistics":
    • Exception handling added.
    • General code improvements.
    • New parameter introduced: max databases per graph.
  • Job "Buffer cache reads per database":
    • Exception handling added.
    • New parameter introduced: max databases per graph.
  • Management (Performance module):
    • Buffer Hit Ratio now displayed both in graph and accompanying data table.
    • Visuals for several graphs improved.
    • Documentation updated for clarity and guidance.
  • Management (Offline databases):
    • Offline databases now marked with orange icon and “(OFFLINE)” label.
    • New menu options to bring databases online or offline.
  • Job "Backup check - WAL": Exception handling added.
  • Job "Backup check - pg_dump": Exception handling added.
  • Job "DBMS uptime": Exception handling added.
  • Job "Schema growth collector": Excludes "offline" databases (datallowconn = false).
  • Job "Vacuum alert": Excludes "offline" databases.
  • Job "Log size statistics": Exception handling added.
  • Job "Schema growth statistics": Exception handling added.
  • Job "Tablespace growth and information": Exception handling added.
  • Job "Database growth rate and info": Exception handling added, excludes "offline" databases.
  • Job "Buffer cache statistics": Exception handling added.
  • Job "Disk block hitrate": Exception handling added, excludes "offline" databases.
  • Job "Disk block reads per database": Exception handling added, excludes "offline" databases.
  • Job "Table and index scan statistics":
    • New parameter introduced: max objects per graph.
  • Job "Replication delay alert":
    • No longer reports unnecessary delay info for primary instance in a Patroni cluster and now identifies it simply as the primary.

Fehlerkorrekturen

• Oracle
  • Job "Instance alert log": Now compatible from Oracle 12.2 and not 12.1 (due to too many rows returned by V$DIAG_ALERT_EXT).
  • Parameter "max_lines" changed to "max lines".
  • The job "Instance alert log 11" is designed for use with Oracle versions 11 and 12.1.
• Sybase ASE
  • Job "User connections check": Now checking "number of user connections" parameter value.
  • Engine: Error when upgrading jobs. The version number does not change.
• Postgres
  • Job "SQL Statistics": Bug fixed where job incorrectly collected SQL statement statistics based on high values of blocks read instead of blocks hit. This caused statements with low I/O (i.e., primarily served from cache) to be excluded from being collected.