dbWatch AS

Release notes

New in dbWatch 12.9.2

17. Apr. 2023 – ( Download )

New features

  • support for MS SQL Server 2022
  • support for Postgres 15

Improvements

  • MS SQL Server -new version of “MS SQL Server patch status” (2.0) job – added patches up to 15th Mar. 2023
  • MS SQL Server – New “Create snapshot” menu in management.

Bugfix

  • PostgreSQL – new version of “Commit ratio” (1.1) – bugfix when both alarm and warning occurs

New in dbWatch 12.9.1

5. Dec. 2022 – ( Download )

New features

  • DBW – Migrate to Control Center functionallity.
  • PostgreSQL – New job “Blocking statistics”. Check for blocked og blocking processes.

Improvements

  • MS SQL Server – New version of “AlwaysOn database backup” job. Supports instances on the same host.

Bugfix

  • Oracle – Full version display fix for Oracle 18 +

New in dbWatch 12.8.12

14. Oct. 2022

Bugfix

  • MS SQL Server – new version 1.8 of “MS SQL Server patch status.” Checks for new patches for MS SQL 2014, 2017, and 2019 that where released before 28. Sep 2022.
  • MS SQL Server – new version 1.4 of “Sessions per database.” An incorrect query creates an exception on MS SQL 2009.
  • MS SQL Server – new version 2.3 of “Uptime statistics.” UTC dates show up as the wrong week number.
  • Oracle – Fix in management, incorrect statement when adding datafiles with OMF.
  • Postgres – Fix in replication delay alert, delay time shows up incorrectly.
  • Postgres – Support for Postgres 14.
  • Postgres – Changes in driver search priority, fixing connection issues.

New in dbWatch 12.8.11

02. jun. 2022

Bugfix

  • MS SQL Server – new version 1.3 of “Sessions per database”. Fixed NOT NULL constraint error, improved exception handling
  • MS SQL Server – new version 1.2 of “Database growth rate (aggregated)” —> SUP-931 – Fix for arithmetic overflow (error converting expression to data type int) for databases larger than 2.1 TB
  • MS SQL Server – new version 1.8 of “Database growth rate (detailed)” —> SUP-931 – Fix for arithmetic overflow (error converting expression to data type int) for databases larger than 2.1 TB
  • MS SQL Server – new versjon 2.1 of “Transaction log size check” —> SUP-931 – Fix for arithmetic overflow (error converting expression to data type int) for databases larger than 2.1 TB
  • MS SQL Server – new versjon 1.7 of “Blocking statistics” —> Better handling of NULL values in details.
  • DBW – Bugfix for engine job session leak
  • DBW – Bugfix formatting reconnection failed emails

New in dbWatch 12.8.10

05. may. 2022

Improvement

  • MS SQL Server – New version 1.8 of “Session load Rac” oracle. Transformed to an alert, with 8 new parameters (need dbWatch Server restart after upgrade).
  • MS SQL Server – New version 2.4 of “Session load” oracle. Transformed to an alert, with 4 new parameters (need dbWatch Server restart after upgrade).
  • MS SQL Server – New version 2.2 of “Database disk capacity” sqlserver. Supports now log list of drive specifications.
  • MS SQL Server – New version 1.6 of “MS SQL Server patch status”. Checks for patch CU16 for MS SQL 2019 and patch RTM CU28, RTM CU29 for MS SQL 2017.

Bugfix

  • Disks space check for new Windows versions
  • Oracle session load no longer kills old sessions with ORA-0 error
  • CLI – fixed missing driver info for instance export
  • CLI – cleanup of output

New feature

  • Support for Oracle 21

New in dbWatch 12.8.9

16. mar. 2022

Bugfix

  • DBW – Bugfix in Email extension
  • MS SQL Server – New version (1.8) of “framework” task. Fix for version 2000 (database centric alerts).
  • MS SQL Server – New version (1.7) of “Database growth rate (detailed)”. Missing parameter when new installation.
  • MS SQL Server – New version (1.5) of “MS SQL patch status”. Checks patch level of SQL Server instance.

New in dbWatch 12.8.8

16. feb. 2022

New features

  • MS SQL Server – New version (1.4) of “MS SQL patch status”. Checks patch level of SQL Server instance.
  • MS SQL Server – New job “Shrink transaction logs”. Shrinks tr. logs detected by “Transaction log size check” alert

Improvement

  • MS SQL Server – New version (1.61) of “Check database recovery mode”. Excludes mirrored and Availability Groups databases.
  • MS SQL Server – New version (1.4) of “Database backup (system databases)”. Added to new parameter for better configuration flexibility
  • MS SQL Server – New version (1.72) of “Index usage statistics”. More trace info for exceptions (excludes tempdb database)
  • MS SQL Server – New version (2.54) of “DBCC CHECKDB”. Added new parameter “ignore errors” to exclude irrelevant exceptions
  • MS SQL Server – New version (1.3) of “Transactions log flushed bytes load”. Improved exeption handling
  • DBW – Removed old version of log4j

Bugfix

  • MS SQL Server – Bugfix in Management database compatibility menu
  • Oracle: Disk space check did not displace space correctly on Windows Server 2019
  • Oracle: New check, Database mount status, alerting if database is up in wrong mount status. Useful for instances that is part of automated database restore tests where schema can not be installed

New in dbWatch 12.8.7

22. dec. 2021

Bugfix

  • Postgres Backup WAL check now works better for Postgres 12 and 13

New features

  • MS SQL Server – new task: Database session load

Improvements

  • MS SQL Server – new version: Database growth rate detailed
  • MS SQL Server – new version: Database disc capacity
  • MS SQL Server – new version: Filegroups growth rate
  • Oracle – new version: Delete SYS.AUD$ data
  • Postgres -new version: Session load

New in dbWatch 12.8.6

20. sept. 2021

Bugfix

  • Bugfix for PostgreSQL reconnect

Improvement

  • Improved audit
  • Improved Cipher suite

New in dbWatch 12.8.5

01. sept. 2021

Improvement

  • Improved handling of Oracle RAC
  • Improved compatability handling for no engine alerts
  • More configurable certificate loading
  • Oracle Dataguard archive sequence apply lag, improved query to handle systems multiple threads and incarnations
  • Oracle Temporary tablespace free space check, added improved privilege checks
  • Oracle ASM diskgroup alert (for monitoring without schema or Dataguard), new basic report added
  • Oracle Dataguard apply time, new basic report added
  • Oracle Dataguard archive sequence apply lag, new basic report added
  • Oracle Dataguard gap alert, new basic report added
  • Oracle Dataguard startup time, new basic report added
  • Oracle Dataguard transport time, new basic report added
  • Oracle Extent fragmentation alert (for monitoring without schema or Dataguard), new basic report added
  • Oracle Flash recovery area alert (for monitoring without schema or Dataguard), new basic report added
  • Oracle Max datafiles alert (for monitoring without schema or Dataguard), new basic report added
  • Oracle Max processes alert (for monitoring without schema or Dataguard), new basic report added
  • Oracle Password expire alert (for monitoring without schema or Dataguard), new basic report added
  • Oracle RMAN backup status alert (for monitoring without schema or Dataguard), new basic report added
  • Oracle RMAN last run alert (for monitoring without schema or Dataguard), new basic report added
  • Oracle SYS aud$ (for monitoring without schema or Dataguard), new basic report added and bugfixes
  • Oracle Tablespace free space alert (for monitoring without schema or Dataguard), new basic report added
  • Oracle Test alert (for monitoring without schema or Dataguard), new basic report added
  • New version of MS SQLServer “Agent Jobs Check” 2.7
  • New version of MS SQLServer “framework” 2.2
  • New version of MS SQLServer “Database disk capacity” 2.0
  • New version of MS SQLServer “Wait statistics” 1.6

Bugfix

  • Bugfix for uninstall database centric alerts on MS SQLServer
  • Oracle Datafile status (for dataguard node), changed scheduled interval from 1m to 20m
  • Oracle Dataguard apply time (for dataguard node), changed scheduled interval from 1m to 10m
  • Oracle Dataguard archive sequence apply lag (for dataguard node), changed scheduled interval from 1m to 10m
  • Oracle Dataguard startup time (for dataguard node), changed scheduled interval from 1m to 10m
  • Oracle Dataguard transport time (for dataguard node), changed scheduled interval from 1m to 10m
  • Oracle Password expire (for dataguard node), changed scheduled interval from 1m to 1h
  • Oracle RMAN backup (for dataguard node), changed scheduled interval from 30m to 1h
  • Oracle RMAN last run (for dataguard node), changed scheduled interval from 15m to 1h
  • Oracle SYS.AUD size (for dataguard node), changed scheduled interval from 15m to 1h
  • Oracle Tablespace free space (for dataguard node), changed scheduled interval from 1m to 1h
  • Oracle Instance alert log check, improved handling of ORA-0 errors/messages
  • Oracle Temporary tablespace free space check, removed upgrade bug that made it only monitor permanent tablespaces
  • Oracle Database uptime check, error in report fixed and also spelling mistakes
  • Oracle Listener log check (java), fixed duplicate naming issue
  • Postgres Locks held, fixes bug during reinstallation
  • Postgres Transaction statistics, fixes bug during reinstallation

New in dbWatch 12.8.3

10. may 2021

Bugfix

  • [DBW-638] – Login dialog no longer attempts continous login while typing.
  • New Azure alert MS SQLServer “Index fragmentation alert”
  • New version MS SQLServer “Transaction log space usage”

Improvement

  • [DBW-640] – Add instance, no longer allows identical dbwatch user and install user.
  • [DBW-639] – Improved handling of monitor credential storage policy.
  • New version of MS SQLServer “Database growth rate (detailed)”
  • New version of MS SQLServer “Filegroups growth rate”
  • New version MS SQLServer “Database disk capacity”
  • MS SQLServer: Improved support for no-engine alerts
    • Instance memory check
    • Blocking detector
    • Database status
    • Missing database log backup
    • Missing database full backup
    • Database log backup
    • Database full backup
    • Disk space check
    • Transaction log space usage
    • Instance restart alert
    • Data file size check

New in dbWatch 12.8.2

19. apr. 2021

Improvements:

  • Oracle: Support for displaying multitenant databases in management
  • Oracle datafile status for Dataguard, local report added
  • MS SQLServer: Improved “Temporary database space usage” alert
  • MS SQLServer: New alert “Version store space usage (tempdb)”
  • MS SQLServer: Improved “Filegroups growth rate” alert
  • MS SQLServer: Improved “Internal fragmentation check” alert
  • MS SQLServer: Improved “Data cache memory usage” task

Bugfix:

  • Oracle job scheduling check, occasional exception when jobnames not as expected
  • Oracle analyze tables maintenance job, improved exception handling
  • Oracle rebuild indexes maintenance job, improved exception handling
  • Oracle management, drop object now will do a correct refresh
  • PostgreSQL Logical reads graph has better historical data
  • PostgreSQL Session graph has better historical data
  • PostgreSQL Analyze check, now updates statistics tables correctly
  • PostgreSQL Analyze job, now updates statistics tables correctly
  • PostgreSQL Backup check ssh, now updates statistics tables correctly
  • PostgreSQL PG Dumpall, now updates statistics tables correctly
  • PostgreSQL Scan statistics, now updates statistics tables correctly
  • PostgreSQL Schema growth and info, now updates statistics tables correctly
  • PostgreSQL Table and index statistics, now updates statistics tables correctly
  • PostgreSQL Vacuum job, error in exception handling

New in dbWatch 12.7.13

04. feb 2021

Improvements:

  • Improved support for PostgreSQL 13
  • MS SQLServer: Now possible to add more than one schedule to a job
  • MS SQLServer: Improved ‘DBCC CHECKDB’ job
  • MS SQLServer: Improved ‘Autogrow settings’ job
  • MS SQLServer: Improved ‘Data file size check’ job

New in dbWatch 12.7.12

16. dec 2020

Bugfix

  • Setting of jdbc parameters for MySQL now works.
  • Bugfix in session handling for slow standard tasks.
  • Oracle: Fix for tablespace warning info not showing when dba_recyclebin was full
  • Oracle: Bugfix where sometimes internal log table got dropped resulting in invalid objects
  • Oracle: Bugfix in extent fragmentation alert that would run for a long time when recyclebin had 100K+ objects

New features:

  • Support for PostgreSQL 13
  • Can now set a cpu load threshold that will trigger Server restart.
  • Oracle: Unackowledged errors in instance alert log check now gives warning, even if last scan of the alert log was without errors. (Set parameter “return status when unacknowledged” to “0” for old behavior)

Improvements:

  • Improved feedback for connection failed in add instance wizard.
  • Improved handling of pre install checks for Oracle.
  • Improved restponsetime for test Oracle test connection in add instance wizard
  • Oracle: Improved housekeeping in error logging
  • Oracle: Engine scripts merged and improved
  • Oracle: DBMS waits routine now holds statistics for 14 days by default

New in dbWatch 12.7.8

22. sep 2020

Bugfix

  • Bugfix in task editor – raw mode
  • Bugfix in setting of authentication in sql worksheet
  • MS SQLServer: Bugfix for uptime statistics in Management for no-engine-monitoring instances
  • Oracle: Bugfix in RMAN backup alert, not running on mounted instances / Dataguard
  • Oracle: Bugfix in RMAN last run alert, not running on mounted instances / Dataguard
  • Oracle: Bugfix in Dataguard archive sequence apply lag, typo in sql statement
  • Oracle: Bugfix in dbWatch engine alert, changed compatibility
  • Oracle: Bugfix in Aud table size check, intermittent exceptions fixed in some scenarios, also improved error handling
  • Oracle: Bugfix in Disk space check, fixes for AIX and better error handling
  • Oracle: Bugfix in Archive status check, space in object tag leads to problems during reinstall
  • Oracle: Bugfix in DBMS uptime, space in object tag leads to problems during reinstall
  • Oracle: Bugfix in Export log check, space in object tag leads to problems during reinstall
  • Oracle: Bugfix in Listener log check, space in object tag leads to problems during reinstall
  • Oracle: Bugfix in Disk space check, space in object tag leads to problems during reinstall
  • Oracle: Bugfix in Delete audit records, space in object tag leads to problems during reinstall
  • Oracle: Bugfix in Instance memory statistics, space in object tag leads to problems during reinstall
  • Oracle: Bugfix in Session load, space in object tag leads to problems during reinstall

Improvements

  • Improvement to audit logging
  • Improvement to handling of filesizes in property storage
  • MS SQLServer: New version of “Deadlock event collector” now as an alert
  • MS SQLServer: New version of “Database status” (new parameter)
  • Oracle: Improvement in Datafile status (on Dataguard), improved error message
  • Oracle: Improvement in Delete audit records, improved throttling and configurations

New features

  • MS SQLServer: Added database centric functionality for 15 alerts.

New in dbWatch 12.7.4

30. jul 2020

Bugfix

  • MS SQL Server: Bugfix in engine scripts

New in dbWatch 12.7.3

01. jul 2020

Bugfix

  • Oracle: Bugfix in Analyze tables report
  • Oracle: Bugfix in Rebuild indexes report
  • Oracle: Bugfix in Disk space check adding force install if it exists conflicting objects
  • Oracle: Bugfix in Alertlog check, default ignoreing ORA-0 messages
  • Postgres: Bugfix duplicate version tag creates major additional problems in using Postgres

Improvements

  • Oracle: Improved error detection in DBA jobs check
  • Oracle: Improved statistics for Buffer cache statistics

New in dbWatch 12.7.2

24. feb 2020

Bugfix

  • [DBW-394] – Alert “Agent Jobs Check” fails with an exception
  • [DBW-409] – DBCC gir ikke warning/alarm ved exception
  • No alerts or tasks on Dataguard nodes for Oracle 18c and 19c
  • No initial dashboard for Oracle 19c
  • Bugfix in Oracle Latch statistics
  • Added ORA-0 errors to ignored messages in Oracle Instance alert log check
  • Bug when installing Postgres 10.7 to 10.9 and 11.7 to 11.9
  • Typo in engine script for Oracle 19c

Improvements

  • [DBW-398] – New parameters for “Database status” alert
  • [DBW-402] – New parameter “online” for Rebuild indexes task
  • [DBW-407] – New version of Instance alert log
  • [DBW-408] – New properties for [Instance alert log] and [Instance error log]

New features

  • Support for Postgres 12

New in dbWatch 12.7.1

19. feb 2020

Bugfix

  • Bugfix for installation on MySQL 8
  • Bugfix for privilege check step on Session load on Oracle
  • Multiple typo bugfixes in Oracle jobs
  • Bugfix in Agent jobs check for MS SQL Server

Improvements

  • [DBW-393] – RAC switch triggering
  • Improved create user for MySQL
  • Improved support for MS SQL Server 2019
  • Improved handling of offline databases in MS SQLServer Management

New features

  • [DBW-392] – Added Ceeview extension
  • Added support for Oracle 19c
  • Added performance reports to MySQL

New in dbWatch 12.6.16

21. okt 2019

Bugfix

  • [DBW-371] – Fix for “Update statistics” in MS SQL Server management.
  • [DBW-372] – Executing report queries from task/report editor does not work

New in dbWatch 12.6.15

09. sep 2019

Bugfix

  • [DBW-345] – dbWatch monitoring sessions uses to much resources
  • [DBW-346] – Error when running uppgrade of Tasks on Oracle RAC instances
  • [DBW-352] – Autodiscover does not discover MS SQL Servers
  • [DBW-354] – Error when installing “Database backup (SIMPLE)” alert

Improvements

  • [DBW-353] – Improved handling of service groupings

New in dbWatch 12.6.11

07. aug 2019

Bugfix

  • [DBW-342] – Not possible to change monitoring database on MS SQLServer.

New in dbWatch 12.6.10

01. jul 2019

New features

  • [DBW-317] – Now possible to create a MS SQLServer login with a dot in the name
  • [DBW-318] – Wait statistics task for MS SQL Server now ignores PARALLEL_REDO_WORKER_WAIT_WORK wait type.
  • [DBW-319] – Added exception handling for Agent Jobs Check for MS SQLServer.
  • [DBW-328] – Data hit ratio task for MS SQLServer now computes logical reads increase periods.
  • [DBW-336] – Can now edit the legal period for autoupgrading tasks.

Bugfix

  • [DBW-314] – Missing “max-age” tags in management performance graphs.
  • [DBW-331] – Fixed spelling mistakes in “Autogrowth settings” task for MS SQLServer
  • [DBW-332] – Bugfix in propertystore files size handling (they were to big).
  • [DBW-333] – Bugfix in uptime topic, showed 0 hours 0 seconds the first time
  • [DBW-334] – Internal/datadir/size shows incorret size
  • [DBW-335] – Trailing space in given-name causes issues for propertystore
  • [DBW-337] – Task autoupgrade does not work

New in dbWatch 12.6.8

29. may 2019

New features

  • [DBW-316] – Support for MS SQLServer 2019.
  • [DBW-309] – New property for instance count (“ms_inst_count”) on MS SQLServer.

Bugfix

  • [DBW-256] – Fix for Oracle “Password expire” alert.
  • [DBW-311] – Fix for Arithmetic overflow bug in MS SQLServer “Lazy writer and Checkpoint statistics” task.
  • [DBW-312] – Fix for “ignore databases” parameter in MS SQLServer “Backup all databases” task.

New in dbWatch 12.6.7

03. may 2019

Bugfix

  • [DBW-236] – Timeout issue during Oracle install.
  • [DBW-296] – Bufix when upgrading parameters in MS SQLServer task “Reorganize indexes”.

Improvements

  • [DBW-213] – Mindre logging av http-events.
  • [DBW-259] – Added new jdbc drivers for Oracle, PostgreSQL, MySQL and MariaDB.
  • [DBW-284] – Multi Server support for Web Dashboard.
  • [DBW-146] – Improvements to Web Dashboard.

New in dbWatch 12.6.6

12. april 2019

New featues

  • [DBW-292] – Need to be able to set jdbc driver properties for MySQL
  • [DBW-294] – New version for “CPU load” alert for Oracle (new aggregerings history table)

Bugfix

  • [DBW-291] – Changing JDBC driver properties requires Server restart
  • [DBW-293] – Configure instance dialog has annoying save changes popup
  • [DBW-295] – Arithmetic overflow in task “Database Server uptime”

New in dbWatch 12.6.5

8. april 2019

New featues

  • [DBW-245] – New properties for database Compability Level
  • [DBW-286] – Ability to select jdbc driver in “Add instance” dialog
  • [DBW-287] – Need to set jdbc driver properties in “Add instance” dialog

Bugfix

  • [DBW-281] – Dataexport to web from SQL does not work for all datatypes
  • [DBW-239] – Notes are not upgraded correctly between dbWatch versions
  • [DBW-237] – Issue with pluggable/container db detection during Oracle install
  • [DBW-263] – Not possible to disconnect an instance with only “standard tasks” installed
  • [DBW-255] – Incorrectly prompts for ;;inst-user;; password during task install
  • [DBW-290] – SSH properties are sometimes prepended with shell output

Improvements

  • [DBW-283] / [DBW-246] – Added better formatting for numbers in table views
  • [DBW-282] – Buggy sorting for some number columns in monitoring views
  • [DBW-244] – Improved “Disk and Memory usage” view in Management
  • [DBW-227] – Missing upgrade of “Max processes” task
  • [DBW-229] – Missing upgrade of “Wait statistics” task
  • [DBW-242] – Bug in Oracle “Session load” task upgrade
  • [DBW-258] – Rebuild indexes fails when using tempdb
  • [DBW-265] – Issue in local rapport for “Wait statistics” task
  • [DBW-267] – “Max processes” task does not upgrade automatically
  • [DBW-268] – Exception in “Long running queries” task for Oracle
  • [DBW-269] – Bug in upgrade of “Disk read statistics” task på Oracle
  • [DBW-270] – Autogrow settings upgrade issue
  • [DBW-271] – Autoshrink settings upgrade issue
  • [DBW-272] – Internal fragmentation check upgrade issue
  • [DBW-273] – SQL Server Agent status upgrade issue
  • [DBW-274] – Auto growth event collector upgrade issue
  • [DBW-276] – Reorganize indexes upgrade issue
  • [DBW-241] – Improved disk-space-usage-graph
  • [DBW-261] – Improved “Instance memory statistics” for Oracle
  • [DBW-280] – Bug in Agent Jobs Check

New in dbWatch 12.6.3

25. february 2019

Bugfix

  • Issues for Oracle install

Improvements

  • [DBW-234] – New properties for oracle “Disk space check”

New in dbWatch 12.6.2

22. february 2019

Bugfix

  • [DBW-185] – Typo in “Check database and server principal mapping” for SQLServer
  • [DBW-188] – Lost the catalog configuration value when moving instance between groups
  • [DBW-189] – Server connection fails directly after server boot.
  • [DBW-223] – Max rows in global report does not work for dbwql queries
  • [DBW-224] – Renaming of instance removes it from scheduled reports
  • [DBW-231] – Issues with demand password change
  • [DBW-177] – Ctl-A in dbwql console and SQL Worksheet

Improvements

  • [DBW-216] – Filter values from dbwql _log queries
  • [DBW-197] – Improved “Show query plan (XML)” in SQLServer management
  • [DBW-143] – Improved handling of read only user
  • [DBW-149] – Improved default queries in web dashboard
  • [DBW-222] – Filter ‘bad’ choices from tablespace list and schema owner list in oracle install
  • [DBW-232] – Show decimal values in Pie chart
  • [DBW-220] – Prevent dbWatch user and sys user to be the same in Oracle install
  • [DBW-221] – Case insensitive filter in dbwql tree

New in dbWatch 12.6.1

12. february 2019

New features

  • [DBW-108] Support for MySQL 8
  • [DBW-107] Support for Oracle 18c
  • [DBW-179] Support for PostgreSQL 11
  • [DBW-178] New monitoring tab “TempDB” for SQLServer
  • [DBW-112] Added support for service name on Oracle
  • [DBW-114] Task parameters can now be changed through the CLI
  • [DBW-110] Resource upload now works on multiple files at once
  • Management files now contain privilege information
  • Disk check using ssh for AIX
  • New “Instance error log” task for MS SQLServer
  • New “Instance error log file size check” alert for MS SQLServer
  • New alert for database and server principal mapping for MS SQL Server
  • New task “dbcc updateusage” for MS SQLServer

Bugfix

  • [DBW-155] Fixed bug that made it immposible to create scheduled reports
  • [DBW-81] Fixed bug when trying to execute sql from task editor in multi server environments
  • [DBW-177] Ctrl + A in worksheet and dbwql console
  • [DBW-157] Fixed bug in instances filtering on some monitoring views
  • [DBW-188] Fixed bug that caused the Azure database connection argument to be lost
  • [DBW-174] Slow statements in some Management dialogs could cause the GUI to hang momentarily
  • [DBW-189] Server connection could fail right after boot
  • Bugfix for Oracle container and pluggable databases
  • Bugfix dashboard for Oracle 12c and 18c
  • Bugfix dashboard for PostgreSQL 11
  • Bugfix dashboard some ghost instances show up as not monitored
  • Bugfix Oracle database link check
  • Bugfix Linux CPU usage check
  • Bugfix Linux Disk usage check
  • Bugfix Postgres Backup job pgdumpall maintenance job
  • Bugfix Postgres Archive status check
  • Bugfix Postgres Replication delay check
  • Bugfix Postgres Transaction statistics task
  • Bugfix Postgres Schema growth and info task
  • Bugfix Postgres Management now displays procedures correctly
  • Bugfix removed forced css settings from management
  • Bugfix Linux properties timing issue
  • Bugfix Oracle CPU load check
  • Bugfix Postgres backup check using ssh

Improvements

  • [DBW-171] Better feedback from long running statements in management
  • [DBW-53] Improved flow in initial webserver setup
  • [DBW-121] More robust xml storage with CDATA tags
  • [DBW-143] Improved handling of “read only” user
  • [DBW-176] Better feedback when trying to make illegal changes in the Operators dialog
  • [DBW-198] Removed spacing in the management breadcrumb
  • Improved “Replica state” task for MS SQLServer
  • Improved “Database disk capacity” task for MS SQLServer
  • Improved “Database disk space usage” task for MS SQLServer
  • Improved “Transaction log space usage” task for MS SQLServer
  • Improved “Cleanup MSDB history tables” task for MS SQLServer
  • Improved “DBCC CHECKDB” task for MS SQLServer
  • Improved “Rebuild indexes” task for MS SQLServer
  • Improved “Reorganize indexes” task for MS SQLServer
  • Improved “Update index statistics” task for MS SQLServer

New in dbWatch 12.5.1

28. november 2018

Bugfix

  • Fixed bug in table filters
  • Fixed bug that caused resource upload to fail in some network setups

New in dbWatch 12.5

(23. november 2018)

New features

  • New Performance/Capacity/Maintenance views in Monitoring
  • Added color fomatting to dbwql console
  • Added #labelwidth hashtag to #renderbar in dbwql views

Improvements

  • Import_area default location moved to data catalog
  • Improved Web configuration dialog
  • Improved #renderbar/#renderpercent hashtag in dbwql views (now handles > 100%)
  • Improved “Rebuild indexes” task for MS SQL Server (supports IsMergePublished, IsPublished, IsSubscribed databases)
  • Improved “Reorganize indexes” task for MS SQL Server (supports IsMergePublished, IsPublished, IsSubscribed databases)
  • Improved “Update index statistics” task for MS SQL Server (supports IsMergePublished, IsPublished, IsSubscribed databases)
  • Improved “Transaction log space usage” task for MS SQL Server (includs statistics on log_reuse_wait)
  • Improved “Instance memory check” task for MS SQL Server

Bugfix

  • Bugfix in uninstall Sybase task
  • Bugfix in property resolving after polling pause end
  • Bugfix in #renderint for dbwql views

New in dbWatch 12.4.4

(5. oktober 2018)

New features

  • Greatly improved support for PostgreSQL
  • Added SSH capability to Standard task javascript steps
  • Local reports for standard tasks now possible
  • Added support for SQL in web dataexport
  • Added breadcrumb in management view
  • New performance overview for MS SQL Server in Management view.

Improvements

  • Improved look & feel in Monitor
  • Improved error reporting in Standard task javascrip steps
  • Improvements to handling of x-axis minimum range in timed charts
  • Improved flow for first startup of Monitor
  • Added “Not monitored” category to main status view
  • Improved task “Rebuild indexes” for MS SQL Server
  • Improved task “Reorganize indexes” for MS SQL Server
  • Improved task “Update index statistics” for MS SQL Server
  • Improved task “Transaction log space” for MS SQL Server
  • Improved task “Instance memory check” for MS SQL Server

Bugfix

  • Fix for sporadic missing standard task parameters
  • Fixed stability issue in import_area.
  • Stability issues in web config ui
  • Linux CPU usage alert: Bugfix: Exception issue when server responded too slow to requests
  • Linux Disk usage alert: Bugfix: Wrong column names in report
  • MS SQL Server and Postgres – register parameter when upgradering tasks

DBMS Specific

PostgreSQL

  • Linux: New maintetance job: Backup job pgdumpall for running backup through a ssh connection
  • Linux: New alert: Backup check (ssh) for checking pgdumpall backups through a ssh connection
  • New/rewritten maintenance job: Analyze: For running analyze on the databases on an instance
  • New/rewritten maintenance job: Vacuum: For running vacuum on the databases on an instance
  • New task: Scan statistics that checks for index scans with built in report
  • New task: Transaction statistics that checks for commits with built in report
  • New task: Buffer cache reads: Analyzes buffer cache hit ratio
  • New task: Disk block reads: Analyzes disk block hit ratio
  • New task: Index block hitrate: Analyzes index hitrate
  • New task: Table and index scan statistics
  • New task: DML performance test
  • Bugfix: Archive status alert: Correct message when archiving was never used
  • Bugfix: Replication delay alert: Correct message when replication has not been implemented
  • Bugfix: Schema growth and information: Improved report and works better on instances with many databases
  • Bugfix: Backup job pgdumpall: Better exception handling
  • Bugfix: Analyze check: Works better on instances with many databases
  • Improvement: Max connections: Added report to alert
  • Improvement: Replication delay: Added report to alert
  • Improvement: Replication slave client: Added report to alert
  • Improvement: Autovacuum freeze: Added report to alert
  • Improvement: Commit ratio: Added report to alert
  • Improvement: Table and index bloat: Added report to alert
  • Improvement: : Added report to alert
  • Bugfix: Administration, Instance general info table: Fixed typos
  • Bugfix: Administration, Databases, Functions: Corrected listing of functions with parameters
  • Bugfix: Administration, Sessions graph: Improved intervals, range and plotting
  • Improvement: Administration: Aligned plotting history, adjusted columns and headers
  • Improvement: Administration: Added sessions pr application

Oracle

  • Bugfix: Administration, Logical reads graph: Improved intervals, range and plotting
  • Bugfix: Administration, Logins graph: Improved intervals, range and plotting
  • Bugfix: Administration, Datafiles, Toggle autoextensible: Corrected handling of increment by
  • Improvement: Administration, Datafiles: Added listing of increment by value

MS SQL Server

  • New task: Log shipping secondary

New in dbWatch 12.3.16

Improvements

  • Improved internal fragmentation check for MS SQL Server
  • Maintenance severity property extended with “Fragmentation check”
  • Improved “Reorganize indexes” task for MS SQL Server
  • Improved “Rebuild indexes” task for MS SQL Server

New in dbWatch 12.3.11

Bugfix

  • Fix bug with queries containing ;;dbw~schema;; in report editor
  • Removed sporadic duplicate rows in the “Blob info” view
  • Fixed bug that caused disconnected instances to be connected after upgrade
  • Fixed bug that caused extensions to be disabled after upgrade
  • Fixed bug in Deadlock event collector for MS SQL Server
  • Fixed bug in nightly task upgrade
  • Fixed annoying popup when selecting a “standard” task in the monitor
  • Bugfix in MS SQL Server “Instance status” alert when handling large values.
  • Bugfix in “Instance alert log” when handling large messages
  • Bugfix in task raw editor that added extra spaces
  • Bugfix in “Tempdb space usage” task for MS SQL Server

Improvements

  • New parameter “max delete size” in the “Cleanup MSDB history tables” maintenance task
  • Improved displaying of space usage in MS SQLServer management

New features

  • Added 2 level tabs in monitoring views
  • Added menu for defragmentation of HEAP tables in MS SQL Server management
  • Added new view for running jobs in MS SQL Server management
  • Added driver properties for MS SQL Server

New in dbWatch 12.3.10

Bugfix

  • Changing passwords in add new server dialog now works.
  • Using standard alerts caused lost connection signals to dissapear in some settings
  • Health check report for MS SQLServer failed when using non default database
  • Fixed bug in Last Analyzed column for MS SQLServer management under Databases – Schemas – Tables

Improvements

  • Improved Active Directory Support
  • Health check report for MS SQLServer now states prerequisit tasks that must be installed
  • Improved the way the maintenance_severity property is computed

New in dbWatch 12.3.9

Internal version – not released to public

New in dbWatch 12.3.8

Bugfix

  • Bugfix Changing passwords.
  • Bugfix Reduced logging of lost connection.
  • Bugfix Saving a monitor tab jumps to a different tab.

Improvements

  • Improved Active Directory Support
    • Test configuration from the configure dialog.
    • Change the timeout of AD authentications.
  • Public notes made available in dbwql.

New in dbWatch 12.3.7

Bugfix

  • Bugfix for Maintenance task “Rebuild indexes”
  • Bugfix in memory graph on PostgreSQL
  • Bugfix in Maintenance task analyze tables
  • Bugfix in Maintanance task delete old audit records

Improvements

  • No longer need seperate maintenance task for AlwaysOn
  • Improvements to Performance tasks – «File IO statistics» and «Waits statistics» for MS SQL Server
  • Improved waits information in active sessions view on Oracle

New features

  • Ny Maintenance task «Cleanup msdb history» for MS SQL Server

New in dbWatch 12.3.6

Bugfix

  • Fixed stability issues in ssh connections
  • Fixed graphical glitch in manage tasks and alerts view
  • Fixes for SSH queries and SSH based tasks

New features

  • Added maintenance task analyze tables for Oracle
  • Added maintenance task rebuild indexes for Oracle

Improvements

  • Improved history in waits views, when task is installed (Oracle)

New in dbWatch 12.3.5

Bugfix

  • Fixed issues when saving changes to AD configuration

Improvements

  • More robust Nagios extension

New in dbWatch 12.3.4

Bugfix

  • Fixed bug that caused disconnected instances to still show standard tasks as active

New in dbWatch 12.3.3

Bugfix

  • Fixed bug that caused long running maintenance tasks to be triggered multiple times

New in dbWatch 12.3.2

New features

  • Tabs in monitoring view
  • Can now set context in dbwql console
  • Now stores lost connection history
  • Can now name docked dbwql consoles
  • New task “Cycle error log” for MSSQL Server

Improvement

  • improved handling of favourites in dbwql console
  • Can now minimize monitoring and management trees
  • Improved MariaDB support
  • Changed name of MySQL process alert to MySQLd process alert
  • Added ostype property for Oracle
  • Improved DTU test for Azure and MSSQL Server
  • Added task properties for a number of performance and capacity tasks
  • Improved Agresso module
  • New versions of a number of tasks and alerts for MS SQL Server
  • Improved Health check reports

Bugfixes

  • Fixed framework placement bug in postgreSQL
  • Fixed bug when deleting authentications
  • Fixed notes handling for standard tasks
  • Fixed upgrade issue for “group by” settings
  • Fixed bug that caused the “tm” sign to hang pdf report generation
  • Fixed bug that caused to monitor to complain of lost connection to removed Servers
  • Fixed graph problems in MySQL 5.7 management
  • PostgreSQL 9.6 bugs
  • Exception bug fixed in Oracle Alert Log check
  • Added spider chart
  • Fixed MySQL Aborted connects
  • Joined admin xml files for MySQL versions
  • Fixed multiple bugs in Oracle temp free space check

New in dbWatch 12.2.9

New features

  • Task autoupgrade
  • Auditing of all database statements

Improvement

  • Dynamic parameters in properties

New in dbWatch 12.2.8

Improvement

  • Improved default file placement for MS SQLServer

New featues

  • MS SQLServer task – Waits statistics

New in dbWatch 12.2.7

Improvement

  • E-Mail format now configurable pr. rule

New featues

  • Performance management in PostgreSQL
  • Oracle management patchinfo view
  • Oracle maintenance job Analyze table
  • Oracle maintenance job Rebuild index
  • Mysql alert aborted connections
  • Mysql alert max connections
  • Mysql alert Mysqld process
  • Linux alert CPU usage
  • Linux alert Disk usage
  • PostgreSQL alert Archive status
  • PostgreSQL alert Max connections
  • PostgreSQL alert Replication delay
  • Support for MySQL development versions 6 and 8
  • Support for MariaDB version 10.0, 10.1, 10.2 and 10.3
  • Support for PostgreSQL 9.6 and 10.0

Bugfix

  • Incorrect load graph on PostgreSQL on Linux when framework was not installed
  • Bug in management framework installation on PostgreSQL
  • Bug in Oracle recyclebin view

New in dbWatch 12.2.6

Bugfix

  • Fixed bug in E-Mail extension that caused issues with some tls/ssl combos

Improvement

  • New version of MS SQLServer task “Agent jobs”
  • New version of MS SQLServer task “Replication status”
  • Several minor improvements in management specifications

New features

  • New MS SQLServer task “Update index statistics”

New in dbWatch 12.2.5

Bugfixs

  • Fixed save bug in task editor

Improvement

  • Can now change server management spec from gui
  • Dictionaries now included when upgrading
  • GUI improvements in attach/detach

New in dbWatch 12.2.4

Bugfixs

  • Editing a scheduled report no longer invalidates authentications
  • Fixed hangbug when running tasks from CLI
  • Fixed bug in “Transaction log space usage” for MS SQLServer
  • Fixed bug in “File IO statistics” for MS SQLServer

Improvements

  • Can now restrict access to resource files

New in dbWatch 12.2.3

New features

  • New metadata editor
  • New metadata dictionary editor
  • New task “Deadlock event collector” for SQLServer

Improvements

  • Improved instance preselection when navigating to management
  • New version of “Autogrow settings” alert for SQLServer
  • New version of “Autoshrink settings” alert for SQLServer
  • Beta support for SQLServer 2017
  • Added possibility to restrict access to management files in the security settings. Useful for creating read-only users.

Bugfixes

  • Fixed bug in server disconnect
  • Fixed bug in setting of current database when creating MySQL reports
  • Fixed resize bug in notes dialog
  • Fixed scroll lock bug in Management log

New in dbWatch 12.2.2

New featues

  • Now possible to autoupdate the license

Improvement

  • SQLServer authentications with empty username/password now converted to OS Authentication.
  • Server menues in the main footer are now sorted alphabetically.
  • All groovy based standard tasks now converted to javascript
  • New version of MS SQLServer Autoshrink settings alert (1.3)
  • New version of MS SQLServer Autogrow settings alert (1.4)
  • New version of MS SQLServer Collation check

Bugfixes

  • Fixed bug that caused disabled standard alerts to effect instance status after server restart.
  • Lost connection to server popup no longer appears multiple times.
  • License expired dialog no longer appears multiple times.

New in dbWatch 12.2.1

New featues

  • Support for Javascript properties
  • The main tabs can now be detached as free floating windows
  • New “Database backup” global report for Oracle and MS SQLServer
  • New alert “Collcation check” for MS SQL Server
  • New task “Auto growth event collector” for MS SQL Server
  • New alert “Autogro settings” for MS SQL Server
  • New alert “Autoshrink setting” for MS SQL Server
  • New button: Make default temporary tablespace – to change what is default temporary tablespace in Oracle
  • New task “Tablespace free space” (Standard alert) for Oracle
  • New task “Test alert” (Standard alert) for Oracle

Bugfixes

  • Management dialogs did not close after “OK” click
  • Layout bug for Operator dialog on small screen sizes
  • Multiple “Installed OK” boxes appeared when using task centric task installation
  • Fixed filter bug in error log view
  • Fixed bug in AD handling when AD server was not found
  • Fixed bug in report tablecell color formatting
  • Fixed bug that caused global reports with trailing space in their name not to be transferred to the monitor
  • Fixed refresh issue in management when explicitly clicking refresh on a node
  • Fixed bug that caused formatting hashtags to be lost when deleting a presentation row in report editor
  • Fixed bug that caused standard alerts to send a “status ok” email at server startup
  • Fixed bug that caused table to display “loading” when they actually had no data
  • New version of MS SQLServer Transaction log size check
  • New version of MS SQLServer Data hit ratio
  • Fixed calculation error for temporary tablespace usage in Oracle
  • Groovy converted to Javascript for Oracle, MySQL and PostgreSQL
  • Fixed bugs in RMAN backup checks for Oracle 10g, 11g and 12c
  • Fixed bug in File status check for Oracle

Improvement

  • More robust AD handling
  • New look and feel for error dialogs
  • More intuitive menu name for license dialog
  • Changed some misleading error messages with missing privileges
  • Improved logging when performing a RAC switchover/failover
  • More robust saving of server_configuration.xml file
  • Added filter to manage tasks and alerts view
  • Added filter to instance selection in reports dialogs
  • Added filter to report selection in edit report dialog
  • Configure Server dialog now automatically updates connection state
  • Improved logging of failed queries
  • Improved check for write access to central files during server startup
  • Improved handling of SQL results with different column count from multiple sources in SQL Worksheet
  • Improved error reporting when report generation fails (instance name now included).
  • Tables now remembers filter after refresh
  • Added topic statustime to standard tasks
  • Improved sorting for Error log and Agent log in MS SQLServer Management
  • Improved “Blocking sessions” in MS SQLServer Management
  • Improved Rebuild and Reorganize indexes in MS SQLServer Management
  • Imprived DBCC and index Rebuild/reorganize tasks for MS SQLServer
  • Improved interface for creating new temporary tablespaces in Oracle
  • Improved performance dashboard in MySQL
  • Improved session graph in PostgreSQL

New in dbWatch 12.2

  • Added support for Azure.
  • Performance metrics for MS SQLServer and Azure
    • Benchmarks cpu usage, io and memory usage.
  • Much improved Oracle RAC and Dataguard support.
    • Bugfix: Problems adding instance with single Dataguard node
    • Bugfix: Problems skipping Dataguard installation
    • Bugfix: Incorrect Service grouping names
    • Many other minor RAC and Dataguard related bugs
  • Bugfixes in Oracle tasks:
    • Instance alert log
    • Invalid objects check
    • Max datafiles check
    • RMAN Backup status
    • Disk space check
    • Segmenst size collector (large segments)
    • Tablespace free space check
    • Blocking detector RAC
    • Oracle License Information Collector
    • Blocking detector
    • Redo statistics
    • Long running queries
  • New Oracle tasks and alerts (Standard tasks and alerts are alerts that do not require and objects created on the database instance):
    • Extent fragmentation alert
      • Checks for extent fragmentation in dba_free_space. If next extent in Oracle datafiles are set very small you end up with a huge number of extents which will impact many standard Oracle views and give performance issues. (Standard alert)
    • Max processes alert
      • Checks for current processes vs max processes parameter (Standard alert)
    • Password expire alert
      • Checks for passwords about to expire (Standard alert)
    • ASM Diskgroup space alert
      • Checks for available space on ASM diskgroups (Standard alert) (Dataguard compatible)
    • Gather statistics task
      • Gathers historic plotting data for graphs (Standard task)
    • Table statistics check
      • Looks for old and missing statistics
    • Datafile status alert
      • Checks for status changes in v$datafile (Standard alert) (Dataguard only)
    • Dataguard apply time alert
      • Checks for long apply time lag on standby nodes (Standard alert) (Dataguard only)
    • Dataguard gap alert
      • Compares applied redo log threads on primary and standby nodes and alert of long lag (Standard alert) (Dataguard only)
    • Dataguard startup time alert
      • Checks for long startup time reported by standby node (Standard alert) (Dataguard only)
    • Dataguard transport time alert
      • Checks for long transport time reported by standby node (Standard alert) (Dataguard only)
    • Max datafiles alert
      • Checks for number of datafiles compared to controlfile setting (Standard alert) (Dataguard only)
    • RMAN backup status alert
      • Checks for RMAN status for backups run from standby node (Standard alert) (Dataguard only)
    • RMAN last run alert
      • Checks for RMAN last run since time threshold on standby node (Standard alert) (Dataguard only)
    • Flash recovery space alert
      • Checks for flash recovery area space on standby node (Standard alert) (Dataguard only)
  • Oracle Management changes:
    • Fixed scaling issues on low resulutions
    • Better adjusted table views
    • Improved Audit section
    • Bugfix: Performance/Active, Sessions view sometimes not running
    • Improved Redo log group statistics
    • Bugfix: Backup section, RMAN graph sometimes overloading GUI
    • Bugfix: Operation System Manager showing when not supported
    • Speed improvements in many views using dbWQL or stored task data
  • New MS SQL Server tasks and alerts
    • Member state (for AlwaysOn)
      • Checks the status of each member node of the current WSFC cluster
    • Rebuild indexes (for AlwaysOn)
    • Reorganize indexes (for AlwaysOn)
    • Update statistics (for AlwaysOn)
  • Improvements in MS SQL Server tasks and alerts
    • Database Log backup
      • New parameter “exclude databases if new”
    • Database backup
      • New parameter “exclude databases if new”
    • Test DML-DDL performance
      • Improved graphics
    • Replica states
      • Saves history of switching between PRIMARY and SECONDARY status
  • Bugfixes in MS SQL Server tasks and alerts
    • Agent Jobs Check
    • Data file size check
    • Transaction log space usage
    • Data cache memory usage
    • Index usage statistics
    • Rebuild indexes
    • Reorganize indexes
    • Update statistics
  • MS SQL Server management changes
    • Fixed scaling issues on low resolutions
    • Better adjusted table views
  • PostgreSQL Administration and Management changes:
    • Better graphs and GUI
  • MySQL Administation and Management changes:
    • Better graphs and GUI
    • Performance dashboard
  • Improved security system.
    • Easier user interface.
    • Cleaner security model.
  • Improved Active Directory integration
    • It is now possible to have AD and internal authentication at the same time.
    • Greater configurability of AD integration.
    • Supports a wider range of AD servers.
  • Kerberos authentication for Oracle.
    • Dbwatch can log on to Oracle using kerberos tickets obtained from Active directory.
  • Improved report engine
    • Improved dbwql handling in reports.
    • Added “distinct” to reports.
    • Reports can now indicate warning/alarm by coloring table cells.
    • Reports can now have secondary sorting columns.
    • Improved report look & feel.
  • Improved database autodiscover.
    • Significant improvements in scan speed.
    • Scheduling
    • Improved user interface
    • Scanning multiple subnets at the same time
  • Improved error log view.
  • Added management spider chart.
  • Crypto upgraded to TLS 1.2.
  • Maintenance tasks can now have longer timeout.
  • Fixed privilege issues related to file placement on Windows.
  • Many dialogs converted to new look & feel.
  • Reduced Monitor CPU load in large environments.
  • Added “triggered mode” to dbwql console.
  • Added visualization indicating if an instance/task has an attached note.
  • Fixed bug that caused property store file growth.
  • Improved stability of standard tasks.
  • Many bugfixes and minor improvements.

← About dbWatch / Version Summary →

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment