Release notes

dbWatch Control Center (2024-03-11)

Download

Important note

• Linux release is available as an apt repository, see Linux install guide
• All clients and servers need to be upgraded in a multi-server setup before the connection will resume due to network incompatibilites
• Only the server installation is available on Linux in this release (no graphical client or CCC scripting engine)

New features

• MariaDB – Now supported from version 10.2+. For version 10.1 jdbc driver version 2.7.12 must be used for connection insted of 3.3.3. For MariaDB 5.5 only monitoring without local database is supported.
• MariaDB – “SQL statistics” job, collects detailed information about SQL statements executed on the instance. Supported versions: 10.1+. (LICENSED)
• MariaDB – Management – SQL Performance views showing statistics gathered by “SQL statistics” job (LICENSED).
• MariaDB – Monitoring of Galera Cluster; Node state, Node count, Replica queues, Network staistics.
• Oracle/MS SQL Server – New global report template “Uptime statistics”.
• MySQL/MariaDB – New global report template “Health check report”

Bugfix

• DBW – global report download unstability issue
• Oracle – Management. Improved handling of PDB and CDB instances so that statistics are not mixed between them.
• MS SQL Server – “Health state” job, fix when using CS tempdb.
• MS SQL Server – “Autogrowth settings” job. In an earlier version of dbWatch, the job was initially named “Autogrow settings”, but it was subsequently renamed to “Autogrowth settings”. This change has unfortunately led to the confusion and errors.
• MySQL – Engine. Fixed error when upgrading jobs, and fix for jobs with status which appers without status (new framework versjon 1.32).
• MS SQL Server – “MS SQL Server patch status” job, fix for showing wrong cumulative updates version for SQL Server 2019 (CU23/CU24). Last patch for 2019 CU25 5th apr. 2024
• DBW – Fdl now handles escaping in quoted text.

Improvements

• MS SQL Server – “Update index statistics” job. 2 new parameters that make it possible to store statistics per database.
• MS SQL Server – “DBCC CHECKDB” job. Improved local report. If “max elap time” is exceeded during execution of the procedure, the report will contain statistics from previous executions until the last database has been checked.
• MS SQL Server – “Reorganize indexes” job. Improved local report. If “max elap time” is exceeded during execution of the procedure, the report will contain statistics from previous executions until the last database has been checked.
• Oracle – Management. Improved “kill session” menu, so that the session executing “alter system kill session” command does not try to terminate itself.
• MS SQL Server – “Database status” job. Collects statistics for periods where the state of the databases has been different from ONLINE. Two new parameters enable ignoring of databases in a none ONLINE state for a long period of time.
• MS SQL Server – Management. New menu in “Files information” table, showing Drive information (size, free space, used space).
• MySQL – “Maximum connections alert” job. Better feedback when the value of max_connections is not available.
• MS SQL Server – “Backup All databases” job. Two new parameters enable compression and creation of subdirectories for each database.
• MS SQL Server – “Backup All transaction logs” job. Two new parameters enable compression and creation of subdirectories for each database.
• DBW – new framework procedure/function for all database platforms (dbw_registerNewParameter). New framework job for upgrading old installations.
• MS SQL Server – Management. Menu “Create new backup device” automatically creates a file name for the device.
• MySQL – “Network statistics” job, fix for avarage statistics calculation.
• Sybase – “Transaction log space check” job, fix for arithmetic overflow.
• MS SQL Server – “Blocking statistics” job, collects hostname for blocked and blocking sessions.
• MS SQL Serer – Management. Added an new column (hostname) to “Blocked/Blocking sessions history” views (job “Blocking statistics” must be upgraded to version 1.9).
• MS SQL Server – “Database backup” job. New parameter “exclude standby databases”, if set to YES the alert will exclude all databases in state online as read-only, with restore log allowed (IsInStandBy property set to TRUE).
• MS SQL Server – “Database Log backup” job. New parameter “exclude standby databases”, if set to YES the alert will exclude all databases in state online as read-only, with restore log allowed (IsInStandBy property set to TRUE).
• DBW – Network stability
• DBW – Improved coloring of area graphs in management

dbWatch Control Center (2024-01-18)

Download

Important note

• Linux release is now available as an apt repository, see Linux install guide
• All clients and servers need to be upgraded in a multi-server setup before the connection will resume due to new node-to-node communication with TLS if you are running the 2023-09-27 release or older
• Only the server installation is available on Linux in this release (no graphical client or CCC scripting engine)

Bugfix

• Rare connection issue (unable to connect) between some clients and servers dependent on TLS configuration settings on one of the hosts. The issue is known and the fix is being tested. A new release with this fixed is due out shortly.

dbWatch Control Center (2024-01-12)

Download

Important note

• Linux release is now available as an apt repository, see Linux install guide
• All clients and servers need to be upgraded in a multi-server setup before the connection will resume due to new node-to-node communication with TLS
• Only the server installation is available on Linux in this release (no graphical client or CCC scripting engine)

Known issues

• Rare connection issue (unable to connect) between some clients and servers dependent on TLS configuration settings on one of the hosts. The issue is known and the fix is being tested. A new release with this fixed is due out shortly.

New features

• DBW – Node-to-node communication now TLS
• DBW – 2 Factor authentication
• DBW – Forced wait time when login fails
• DBW – Clock skew detection and alerting
• DBW – Secure Cloud Router
• DBW – Metadata on jobs
• DBW – Div minor security improvements
• DBW – Optional anonymous access to web pages
• MS SQL Server – “Security and Compliance” module, contains a set of 40 jobs, a report, and a set of Management views for maintaining security and compliance standards (licensed).
• MS SQL Server – New job “Database compatibility” checks if databases run under lower compatibility mode than the SQL Server instance.
• MS SQL Server – New job “Table size collector” – collects table (HEAP and CLUSTER type) size statistics.
• Oracle – New management view “Space usage history” under Storage statistics
• MS SQL Server – New Management view “Object size history” under “database”/Disk and Memory usage/Largest tables/indexes (top 100)/

Bugfix

• DBW – Email extension – no engine job issue
• DBW – Delete dictionary topics
• DBW – Management pie chart issue
• Oracle – Engine for Oracle 8i, error when creating local job reports for instance centric jobs.
• Oracle – Job “Session load”, fix for aggregated statistics for max. and avg. sessions.
• Oracle – Job “Framework” for Oracle 8i, fix error ORA-1400 for jobs with status warning/alarm
• MS SQL Server – Job “Update index statistics”, the procedure now continues to analyze indexes on the next execution if “max elap time” is reached.
  

Improvements

• DBW – Network message forwarding optimization
• DBW – Div GUI improvements
• DBW – SQL result network handling
• DBW – Report table cell OK marking
• DBW – Report chapter text
• MS SQL Server – Job “AG synchronization lag”. Checks AG synchronization lag time.
• MS SQL Server – Job “Query Store status”, new parameter which enables it to react when Query Store stops.
• MS SQL Server – Job “Objects size collector (all databases)”, new parameter “max objects per graph”, improves visualization of object growth rates in graphs, and new parameter “ignore READ ONLY databases” which enables possibility to ingnore read-only databases.
• MS SQL Server – Job “SQL statistics” increased the max-size value of the database files of the dbwatch database
• MS SQL Server – Job “SQL Server Agent status” new parameter “return status”. Return status value (ALARM – 2, WARNING – 1, or OK – 0) when SQL Server Agent is not running.
• MS SQL Server – Management, improved blockig statistics views.
• MS SQL Server – Job “Blocking statistics”, historical tables include SID values for blocked and blocking sessions.
• MS SQL Server – Job “SQL Statistics”, improved cleanup routine for sql similarity statistics.
  

dbWatch Control Center (2023-09-27)

Download

Important note

• Linux release is now available as an apt repository, see Linux install guide
• Only the server installation is available on Linux in this release (no graphical client or CCC scripting engine)

New features

• DBW – Support for MongoDB (beta)
• DBW – Alert forwarding pause
• DBW – Support for Global Report FDL merge
• DBW – Network layout view (beta)
• DBW – Management charts now have an optional description field
• DBW – Local report can now access task parameters
• DBW – Added FDL difference function
• MS SQL Server – New job “Session statistics”. Collects detailed information about sessions connected to the instance (part of performance module, licensed)
• DBW – Semi-automatic upgrade for dbWatch Server

Improvements

• Oracle – “SQL statistics” job, fix for missing statistics when counters are reset.
• Oracle – Improved blocking sessions view in Management
• MS SQL Server – New blocking sessions view statistics in Management
• MS SQL Server – Job “Backup All transaction logs” supports Case Sensitive instances and parameter “ignore databases” allows spaces when listing database names
• MS SQL Server – Job “Backup All databases” supports Case Sensitive instances, and better exception handling, and parameter “ignore databases” allows spaces when listing database names
• MS SQL Server – Job “Database backup”, new parameter “exclude log shipping databases”
• MS SQL Server – Job “Database Log backup”, new parameter “exclude log shipping databases”
• MS SQL Server – Job “DBCC CHECKDB”, new parameter “return status when exception”
• DBW – Job “Instance restart alert”, better exception handling
• Oracle – Installation – Fix for missing “select any table” privilege for dbwatch database user on Oracle 8i platform.
• DBW – Server down status on click loads connection info
• DBW – Removing a server connection will now close the socket
• DBW – Excludes local specs in the default profile
• DBW – Dynamic title in management views
• DBW – Improved upload resource dialog
• DBW – Domain login select/unselect all
• DBW – Generate report dialog filtered per domain
• DBW – Global report compatibility now fdl
• DBW – Global report SQL compatibility – improved version handling
• DBW – FDL Union handles an unlimited number of sets
• DBW – Better marking of ‘Running’ state for jobs
• DBW – Better Thread handling in javascript execution
• DBW – Category “Unknown” for incompatible jobs
• DBW – Worksheet can show JSON format
• DBW – Engine transfer between instances

Bugfix

• MySQL – Job “SQL Statistics” – error when installing on InnoDB HA-Cluster (fix in version 1.4)
• MySQL – Job “Query cache hitrate” – error when installing on InnoDB HA-Cluster (fix in version 3.1)
• MS SQL Server – Job “Reorganize indexes in table”, parameter “minimum fragmentation” works now
• MS SQL Server – Job “Data cache memory usage”, missing parameter “memory threshold”
• Oracle – Job “Index status check” for Oracle 8i wrong column name when compiling
• Oracle – Job “Disk read statistics” for Oracle 8i to_char compiling error fix* Avoid multiple domain initializations
• DBW – Monitor hang bug
• DBW – Mail format loading
• DBW – Mail multiple ‘lost connection’ messages
• DBW – Access control for web
• DBW – SQL Worksheet – missing results
• DBW – No engine job properties caching issue
• DBW – Report font resolution fix
• DBW – FDL compare number and text fix.

dbWatch Control Center (2023-06-27)

Download

Important note

This release upgrades encryption standards to AES/GCM 256-bit and from Oracle JDK to OpenJDK.
When upgrading from a previous release in a multi-server environment or environments where the dbWatch Server and dbWatch Client is on different machines, all dbWatch Servers and Clients must be upgraded before you can connect again.
If you encounter any issues, please get in touch with support@dbwatch.com, and we will sort it out for you.

Bugfix

• DBW – Fix for socket handling of outgoing connections from the server
• DBW – Test connections from “Node connections” dialog.
• DBW – Edit access points from Domain Login dialog.
• DBW – Delete role/security group
• DBW – Local report hang/slow bug
• DBW – Missing styling in “Show report” from task editor
• DBW – Fixed issue when transferring domain
• DBW – Save as new report did not work correctly
• DBW – Generate report, select instance did not always populate
• DBW – Upload resource, select file dialog did not always appear
• DBW – Lost connection message could be sent multiple times
• DBW/PostgreSQL – Session to multiple databases issue
• Oracle – “RMAN backup status” jobs, exception pos 0. Added new parameter and the backup history table.
• DBW – Farm views – waits statistics pie-charts

New features

• DBW – “Hover” on table text and date cells.
• DBW – Instance access control from web dashboard.
• DBW – Privileges on dbWatch Servers.
• DBW – Restart Server functionallity
• DBW – Domain discovery on/off setting
• Oracle – new job “Applied archive log gap status”
• MS SQL Server – Management – Sessions Performance views showing statistics gathered by the “Session statistics” job (LICENSED).
• DBW – new internal view for session statistics
• DBW – new job “Connection alert” – check connection status for property and engine users.
• Oracle – new job “Flash recovery space usage” for Standby instances.
• MS SQL Server – new job “Test alert” – Useful for testing extensions (not intended for use in production environments).

Improvements

• DBW – Switched to OpenJDK
• DBW – Switched to bouncycastle for crypto
• DBW – Email extension queue and retry
• DBW – License expired dialog contains the server name
• DBW – Job parameter description trimmed.
• DBW – Certificate CN contains the username
• DBW – AD config copied when transferring domain.
• DBW – Improved message crypto (AES/GCM 256-bit)
• DBW – Lost connection email contains more info
• DBW – Can not delete domain controller node
• DBW – Node info dialog
• DBW – Improved error handling in charts
• DBW – Group configuration now available for Super DBA role
• DBW – Notifications dialog
• Oracle – Default max tablespace size now 20GB
• MS SQL Server – Default max database size now 20GB
• PostgreSQL – “Session load” – parameter replacement to percentage. New session aggregation table.
• Oracle – “Job Scheduling Check” – improved execution time of the job.
• Oracle – Management – improved blocking statistics views.
• MS SQL Server – “SQL Statistics” – improved deletion of old data so that the transaction log to the dbWatch database does not become full.
• MS SQL Server (v. 2014 +) – “Database Log backup” and “Database backup”, new parameter: “exclude databases in Always On availability groups”
• MS SQL Server – “AlwaysOn database backup alert” – 4 new parameters, added differential backup check option and uppercase option.
• MS SQL Server – “AlwaysOn transaction log backup” – new parameter – use_uppercase
• MS SQL Server – “AlwaysOn differential database backup” – new parameter – use_uppercase
• MS SQL Server – “Database Server uptime” – improve resource consumption
• MS SQL Server – “Internal fragmentation check” – new parameter “continue on next run”, makes it possible to carry out the job over several days
• MS SQL Server – “External fragmentation (all databases)” – new parameter “continue on next run”, makes it possible to carry out the job over several days
• MS SQL Server – “Data cache memory usage” – collects execution statistics, new parameter disabling running on instances with high memory usage.

dbWatch Control Center (2023-04-27)

Download

Known bugs

• Problem with driver autodetection, so adding SQL Server 2005 and 2008, requires manually changing the JDBC driver during add instance dialogue to the 9.4.0 version of the driver.
• A problem may occur when installing “RMAN backup status” job on Oracle. Typical error: (Exception, ORA-01403). If this is experienced, please get in touch with support for a patch.

New features

• DBW – Added password policy
• DBW – Job templates can now include other templates in priority order
• DBW – Added ‘Resume monitoring’ menu to instances
• Oracle – new job ‘Tablespace in BEGIN BACKUP mode’ – checks if any data files are in BEGIN BACKUP mode.
• MS SQL Server – ‘MS SQL Server patch status’ – added patches up to 21st Apr. 2023
• MS SQL Server – Management, new menu ‘Create snapshot’
• DBW – New Internal FDL Performance view
• DBW – New Internal sessions view

Improvements

• DBW – Improved feedback in test connection for Email extension
• DBW – Better handling of clock skew in certificate validation
• DBW – Job template editor shows parameter description
• DBW – Improvements to session handling
• DBW – More stable connection for Azure
• DBW – Deleting a job template that is in use is no longer allowed
• DBW – Added threshold for thread dump on high cpu usage
• DBW – Improved styling of errors in tables
• DBW – Performance improvements in property loading
• DBW – Improved ‘Lost connection error’ dialog
• DBW – CSV import now creates subgroups
• DBW – Thread optimization for running engine jobs
• DBW – Added popup when hovering on large table cells
• DBW – Changed firewall settings are enforced at once
• DBW – Added ‘single’ hashtag for forcing single-line fdl result
• MS SQL Server – job “High activity monitor” description change for 4 parameters.
• MS SQL Server – job “Rebuild indexes” has new parameter “ignore tables”
• MS SQL Server – job “Database status” new parameter “ignore standby databases”
• MS SQL Server – job “AlwaysOn transaction log backup alert” improved performance on large AlwaysOn clusters (many nodes)
• MS SQL Server – job “AlwaysOn differential database backup alert” improved performance on large AlwaysOn clusters (many nodes)
• MS SQL Server – job “AlwaysOn database backup alert” improved performance on large AlwaysOn clusters (many nodes)
• Oracle – job “Tablespace free space check” better description if too many tablespaces are in warning/alarm state.
• Oracle – job “Job scheduling check” better exception handling and support for % (percent sign) to represent wild card characters for parameter “ignore job names”
• Oracle – job “RMAN backup status” new parameters and now checks incremental level 0 backup.
• Oracle – job “RMAN archivelog backup status” new parameter.

Bugfix

• DBW – Scheduled report instance list showed guid
• DBW – Delete scheduled report
• DBW – EMail issues for lost connection on no engine instances
• DBW – Jump issue when deleting job in Job template editor
• DBW – Fixed ‘back’ button when creating global report.
• DBW – More stable expanding of nodes in Management
• DBW – Issues with ‘pause monitoring’ for no engine instances
• DBW – Rounding error in fdl div function
• DBW – Issues with setting job template in CSV import
• DBW – ‘Pause monitoring’ was always 30 minutes
• DBW – Buggy adding of metadata in the instance configuration view
• DBW – Buggy ‘Edit dictionary’ dialog
• DBW – Loading of worksheet authentications in multi-server environments
• Oracle – Job ‘SQL statements (Logical reads)’ – better exception handling
• Oracle – Removed RMAN backup jobs for PDB databases
• Oracle – Management fix for Session view for CDB and PDB instances
• Oracle – Job “SQL statistics” – CDB instances do not collect statistics for PDB instances
• MS SQL Server – Management menu fix ‘Change compatibility level’ for 2022
• All DBMS platforms – job “Instance restart alert” better exception handling

dbWatch Control Center (2023-03-10)

Known bugs

• Problem with driver autodetection, so adding SQL Server 2005 and 2008, requires manually changing the JDBC driver during add instance dialogue to the 9.4.0 version of the driver.

Bugfix

• DBW – Job templates could sometimes drop dbwatch monitoring objects in the database
• DBW – Instance status was not always updated when uninstalling a job
• DBW – Table filter did not always work
• DBW – Delete last metadata fix
• Oracle – Handling of Service name
• MySQL – Global report handling

New features

• MS SQL Server – New job “Agent error log”, Checks for errors in the Agent error log
  

Improvements

• DBW – Improvements to Job Template GUI
• DBW – Job template deployment more robust
• DBW – Job template copy to Server functionality
• DBW – One time monitoring pause
• DBW – Job deployment messages in a separate log file
• DBW – Improvements to edit metadata GUI
• DBW – Add/remove monitoring database
• DBW – Uninstall job with no installation script
• DBW – Message performance improvement in multi-server, single-domain setups
• DBW – Auditing of domain config changes
• MS SQL Server – New version of “Query Store status” (1.2) job, fix for history data
• MySQL – New version of the “MySQL max connections” (1.2) job, does not change status to OK after WARNING/ALARM (error when using Max_used_connections value)
• MS SQL Server – New version of “MS SQL Server patch status” (1.9), added patches up to 16th Feb. 2023
• MS SQL Server – New version if “High activity monitor” (1.8) job – fix for NULL details when “Page lookups/sec” counter is missing
• Oracle – fix in the local report for “CPU load check” Oracle.

dbWatch Control Center (2023-02-10)

Known bugs

• Problem with driver autodetection, so adding SQL Server 2005 and 2008, requires manually changing the JDBC driver during add instance dialogue to the 9.4.0 version of the driver.

Bugfix

• DBW – Rename instance
• DBW – Access control fix for “Edit connections” in Domain Configuration
• DBW – Refresh bug in “Jobs Status” in Monitoring View
• DBW – Fix for Delete Job Template
• DBW – Escape handling in Job Template config file
• Oracle – Feedback in Worksheet for buggy SQL statements
• MS SQL Server – New version of “High activity monitor” (1.7), Divide by zero error fix
• MS SQL Server – New version of “Objects size collector (all databases)” (1.5), “04 Incorrect syntax near the keyword” fix.
• MS SQL Server – New version of “Transaction log space usage” (2.3), bug fix for invalid usage of DECLARE CURSOR statement
• MySQL – property fix for memory_usage, disk_usage and edition

Improvements

• DBW – Job template mode has been renamed for better readability
• DBW – Improved safeguards when enforcing Job Templates
• DBW – Timeout in SQL Worksheet
  

dbWatch Control Center (2023-02-07)

Known bugs

• Problem with driver autodetection, so adding SQL Server 2005 and 2008, requires manually changing the JDBC driver during add instance dialogue to the 9.4.0 version of the driver.

New features

• DBW – Job Template Editor
• MySQL – New performance tuning module (this functionality is licensed)
• MySQL – New job “SQL statistics.” Collects statistics for the “SQL performance module” available in Management GUI (this functionality is licensed)
• DBW – License Management View
• DBW – Audit of user actions

Bugfix

• DBW – Fix for polling pause edit
• DBW – Email extension Reconnected message
• DBW – Fix for incorrect TLS handling in email extension
• DBW – Custom tabs in the Monitoring view
• DBW – Handling of duplicate properties when using local definitions
• DBW – Task editor slow issue
• DBW – Minor stuff
• MS SQL Server – Set management auth forgot the database
• Oracle – Support for INTERVALYM / INTERVALS
• MySQL – Fix for job upgrade
• PostgreSQL – Fix for job upgrade
• Azure – Management fix for Azure single db

Improvements

• DBW – New look & feel for Group Configuration
• DBW – More robust CSV import
• DBW – Better logging of adding/removing instances to Server Notes
• DBW – Improved formatting of SMS messages
• DBW – Improvements to Access Control
• DBW – Improved handling of parallel sessions in management
• DBW – Edit Jobs available from the Manage Jobs view
• Oracle – New version of “CPU load” (3.7), new parameter “Time threshold”
• Oracle – New version of “Long running queries” (1.6), fix for lowercase
• MS SQL Server – New version if “SQL statistics” (1.6), new parameters to enable/disable similarity query text calculations.
• MySQL – New job “Network statistics” replaces “Network traffic”
• MySQL – New version if “Query cache hitrate”, now with status, new parameters, and better exception handling
• MySQL – New job “Threads statistics” replaces “Thread cache hitrate”
• MySQL – New job “Statement load” replaces “Database load”
• MySQL – New version of “DBMS uptime”, new parameters, and better exception handling
• MySQL – New version of “Binlog cache check”, new parameters, and better exception handling
• MySQL – New version of “Innodb buffer pool check”, new parameters, and better exception handling
• MySQL – New job “MyISAM key cache check” replaces “Buffer key cache check” and “Key buffer check”
• MySQL – New job “Framework”, for internal use only (added new procedure – dbw_remove_job proc)
• MySQL – New version of “Session load”, better exception handling
• MySQL – New version of “Temporary table check”, new parameters, and better exception handling
• MySQL – Improved resolving of Memory and Edition properties

dbWatch Control Center (2022-12-15)

Known bugs

• Problem with driver autodetection, so adding SQL Server 2005 and 2008, requires manually changing the JDBC driver during add instance dialogue to the 9.4.0 version of the driver.

New feature

• DBW – Firewall
• DBW – Command line interface (CCC)
• DBW – Authentication for Web dashboards
• DBW – Web Dashboard Editor now in beta
• PostgreSQL – New job “Blocking statistics”. Checks for blocked and blocking processes.
• MS SQL Server – New job “Autoshrink settings”. Check if all databases have auto-shrink turned off.
• MS SQL Server – New job “AlwaysOn differential database backup”. Check the backup date (type I, differential backup) for all local databases and databases in the AlwaysOn groups (primary and secondary).
• PostgreSQL – Support for Postgres 15 for «SQL statistics» – Performance module.
• PostgreSQL – New “Blocking view” in Management.
• Linux installer included

Improvement

• DBW – More flexible access control.
• DBW – Improved wizard for adding SQL Cluster.
• DBW – CSV import handles multiple license tags.
• MS SQL Server – New version of “AlwaysOn database backup” job (2.9). Now supports instances on the same host.
• PostgreSQL – New version of “Schema growth and information” job (1.8). Improved synchronization with the “Schema growth collector” job, and better exception handling.
• Oracle – New version of “Long running queries” job (3.5). New parameter “Exclude schemas”.
• MS SQL Server – New version of “Transaction log space usage” job (2.2) for MS SQL Server 2017+. DBCC SQLPERF replaced with sys.dm_db_log_space_usage.
• Oracle – Improved handling of Oracle database link in management.

Bugfix

• DBW – Domain configuration – delete node.
• DBW – CSV import – name collision avoidance for Oracle and MS SQL Server.
• DBW – Instance reconnect issue.
• DBW – Fix for HTML-based global reports.
• DBW – Minor fixes.
• PostgreSQL – New version of “SQL statistics” (1.2) job. Fix for deleting of old statistics.
• PostgreSQL – New version of “Vacuum alert” job (2.7). Spelling mistake.
• Oracle – full version display fix for Oracle 18+.

Known bugs

• Problem with driver autodetection, so adding SQL Server 2005 and 2008, requires manually changing the JDBC driver during add instance dialogue to the 9.4.0 version of the driver.
• Importing instance configuration data from dbWatch Enterprise Manager 12, does not work with Oracle RAC and Dataguard systems

dbWatch Control Center (2022-11-03)

New features

• PostgreSQL – No longer beta. Old engine installations must be reinstalled.
• PostgreSQL – new performance tuning module (this functionality is licensed)
• DBW – AD integration
• DBW – GUI for Web Server initialization
• DBW – Web Dashboard now available

Bugfix

• MS SQL Server – New version (1.1) of the “Query Store status” Job. Handles unavailable databases
• DBW – Bugfix instance reconnect issue
• DBW – Bugfix refresh issue in the Manage Jobs view
• DBW – Bugfix job autoupgrade
• DBW – Bugfix fdl orderby NoValue

Improvement

• MS SQL Server – New version (1.5) of the “SQL statistics” Job. Now handles missing indexes
• DBW – QueryLog view now contains SQL
• DBW – Improved edit node connections dialog
• DBW – Improved handling of misconfigured extensions
• DBW – Improved handling of Job installation failure
• DBW – Improved global report generation

dbWatch Control Center (2022-09-29)

Known issues

• SQL Server Consolidation report is visible in the release but is not working as underlying extra cost features are omitted

New features

• MS SQL Server – new performance tuning module (this functionality is licensed)
• MS SQL Server – new job “Query Store status.” Checks Query Store space usage.
• MS SQL Server – new configuration options for Query Store in Management GUI
• MS SQL Server – new job “SQL statistics.” Collects statistics for the “SQL performance module” available in Management GUI (this functionality is licensed)
• MS SQLServer – Kerberos integration
• Oracle – new job “SQL statistics.” Collects statistics for the “SQL performance module” available in Management GUI (this functionality is licensed)
• Oracle – new performance tuning module (this functionality is licensed)
• MariaDB – Now supported
• PostgreSQL – Support for version 14
• DBW – Management graph range restriction/zoom
• DBW – Management selectors
• DBW – Management tabs
• DBW – Management Studio query plan viewer integration
• DBW – Improved CSV import (JDBC driver & global auth)
• DBW – Logging of instance adding to server notes
• DBW – Domain transfer
• DBW – Feedback when license change will disable jobs
• DBW – Freetext notes
• DBW – Job failure log summary

Improvements

• MS SQL Server – new version 1.7 of “MS SQL Server patch status” —> checks for new patches for MS SQL 2014, 2017, and 2019 released before 2022.09.20.
• Oracle – Performance moved into Server activity in management, making room for a new performance module
• Oracle – Improved Amazon RDS support
  

Bugfix

• Oracle – Adding data files and changing storage in OMF
• Oracle – Extending and altering tablespaces in RDS
• Oracle – RMAN information didn’t show up correctly in some instances
• Oracle – Instance alert log check, fixed typo in the report
• Oracle – Fixed bug when adding instances with OMF or ASM
• Oracle – Fixed issue on multi-dataguard sites not being possible to add
• Oracle – Multitenant screen in management stuck on loading
• Oracle – Some management screens stuck on loading
• Oracle instance-id handling in management
• PostgreSQL . Postgres 9.6 is not getting detected correctly in the management module
• PostgreSQL – Replication delay sometimes didn’t detect replication
• PostgreSQL – Fixed typo in property, causing some jobs not to show up
• PostgreSQL – BDR replication job installable on non-BDR setups
• PostgreSQL – SSH-based jobs visible without configuring ssh
• MySQL – Fixed many graphs not showing correctly on some versions
• MySQL – Some management screens are stuck on loading
• MySQL – Issue when uninstalling jobs
• Linux – Fixed issue on CPU usage and Disk usage checks not showing up
• SSH connector stability
• DBW – FDL with restricted access to instances
• DBW – ISsues with triggering of no engine jobs
• DBW – Issues with instance property flush
• DBW – Try again when property resolving fails
  

Note on upgrade
For customers upgrading from previous versions of dbWatch Control Center, be sure to take a backup of the C:\ProgramData\dbWatchControlCenter\config directory. Feel free to contact dbWatch support if you need any assistance. We are happy to help you via zoom or TeamViewer.

Remember that a new “dbWatch Control Center” service is created when you run the installer. If this service has been configured under an account other than the local account, remember to reconfigure it again.

There is also a new license structure. After upgrading, all jobs will execute normally, but installing new jobs and uninstalling already installed jobs may be disabled (depending on your current license). If you experience any issues, contact us, and we will provide you with an updated license.

dbWatch Control Center (2022-05-25)

Bugfix

• DBW – Fix alert triggering with different timezones.
• DBW – Monitor/Server connection issue fix.
• DBW – Fix for lack of automated refresh in management view.
• 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).” 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).” Improved exception handling
• MS SQL Server – new version 2.1 of “Transaction log size check.” Fix for arithmetic overflow (error converting expression to data type int) for databases larger than 2.1 TB
• MS SQL Server – new version 1.7 of “Blocking statistics.” Better handling of NULL values in details.
  

dbWatch Control Center (2022-05-05)

Improvements

• DBW – Added timeout setting for no engine jobs
• DBW – Performance improvements in monitoring for large environments
• DBW – Engine job triggering is more robust
• DBW – No engine jobs use less disk space in the property store
• Oracle – New version 2.8 of “Session load Rac.” Transformed to an alert with eight new parameters (need dbWatch Server restart after upgrade).
• Oracle – New version 3.3 of “Session load.” Transformed to an alert with four new parameters (need dbWatch Server restart after upgrade).
• Oracle – Improved history in session graph
• MS SQL Server – New version 2.2 of “Database disk capacity.” 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, RTM CU28, and RTM CU29 for MS SQL 2017.
• Postgres – Improved history in session graph, logical reads, and transactions per second
• Oracle – Extent fragmentation job – added parameter for skipping tablespaces
• Oracle – Tablespace free space for noschema installation, now supports excluding tablespaces and including unallocated free space
• Postgres – BDR replication lag, new parameter max histr interval, allowing old historical records to be removed automatically
• 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 when an exception occurs. It also excludes the 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.” Better exception handling
  

New features

• DBW – Added views for insight into dbWatch routing and connection info
• DBW – Instance config in separate files
• DBW – Left side tree in monitor now minimizable
• DBW – Single domain multiserver now in beta
• DBW – Lots of changes to internal views
• DBW – Restart the node network in the server’s context menu.
• DBW – Webserver
• DBW – New vmoptions settings for debug output
• Healthcheck report added for Oracle, Postgres, and MySQL
• Oracle – RMAN archivelog backup job, monitoring archivelog backup sets
• MS SQL Server – New alert 1.1 “Shrink transaction logs” – shrinks tr. logs detected by “Transaction log size check” alert
  

Bugfix

• DBW – Lots of fixes for general stability
• DBW – Fixed memory leak for no engine jobs
• DBW – Job template handling
• DBW – Lots of fixes for network stability
• DBW – Changes to group defaults sometimes caused the config file to be corrupted
• DBW – Management specification loading more robust
• DBW – Now handles Oracle timestampz type
• DBW – Unregister instance now works
• DBW – License handling when the license is almost depleted
• MySQL – Uninstall job now works on MySQL 6 and newer
• MySQL – Bugfix for performance-related jobs that did not get correct values
• Oracle – Create user menu option moved to correct location
• Postgres – Bugfix in management security view that was not showing
• MySQL – NDB jobs are now not included in the default install
• Oracle – Alert log check, a minor adjustment in the description
• Oracle – RMAN backup job, now ignoring archivelog backup sets
• Oracle – Autoextensible files job improved compatibility query
• Oracle – Extent fragmentation – Improved query for better database response
• Oracle – Top user memory usage – New default threshold values
• MS SQL Server – New version 1.8 of the “framework” task. Engine fix for SQL Server 2000 (database-centric alerts).
• MS SQL Server – New version 1.2 of “Shrink transaction log.” Bug when deleting history records. (CC)
• MS SQL Server – New version 1.7 of “Database growth rate (detailed).” Missing parameter when a new installation
• MS SQL Server – compatibility fix in Management views
• MS SQL Server – cosmetic fix for local report for [Test DML-DDL performance] job
• MS SQL Server – missing [activity_dtu_test] property. Fix of [Performance test] in the Management view
  

dbWatch Control Center (2022-02-14)

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
• DBW – New fdl topic “iospeed.”
  

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 exception handling
• DBW – Improved stability in multi Server/multi Client setups
• DBW – New implementation of job triggering.
• DBW – More stable property loading
• DBW – Job templates can be triggered for a single instance
• DBW – Improved network logging functionallity
• DBW – More stable Domain Controller startup
  

Bugfix

• MS SQL Server – Bugfix in Management database compatibility menu
• Oracle – Fixed bug in management. Results not showing
• Oracle – Disk space check did not displace space correctly on Windows Server 2019
• Oracle – Rebuild indexes report not displaying correctly
• DBW – Bugfix for initial loading of authentications in SQL Worksheet
  

*Some changes to the config file layout. The server will move the files at the first startup. Some users have experienced needing to restart the server again for the changes to have an effect.

dbWatch Control Center (2022-01-14)

Bugfix

• DBW – Bugfix in the handling of property storage policy
• DBW – Removed false, lost connection messages
• DBW – Metadata dictionary can now delete values
• DBW – Buggy license counting fixed
• DBW – Minor stability issues fixed
• MS SQL Server – Bugfix for “External fragmentation (all databases)” job
• MS SQL Server – Bugfix for “[Check database recovery mode” job
• MS SQL Server – Bugfix for “Index usage statistics (all databases)” job
• MS SQL Server – Bugfix for “Filegroups growth rate” job
• Oracle – Bug fix in compatibility tag that made some jobs disappear from the manage jobs overview
• Oracle – Added pre-implementation steps for some scenarios where jobs didn’t install
• Oracle – Typo fixes in multiple reports
  

New features

• DBW – Job templates – deploy jobs in bulk
• PostgreSQL – Added job BDR Replication lag
  

Improvements

• DBW – Added metadata dictionary key syntax check
• DBW – Lost connection handling Monitor/Server
  

Known issues

• Oracle – Job templates do not work correctly on RAC
  

dbWatch Control Center (2021-12-22)

Bugfix

• Oracle – RMAN 11g Backup check, intermittent exceptions due to lack of privileges
• Oracle – RMAN backup check for 12 and newer, intermittent exceptions due to lack of privileges
• Oracle – Job scheduling check, intermittent exceptions due to lack of privileges
• Oracle – ASM disk statistics check, intermittent exceptions due to lack of privileges
• Oracle – ASM diskgroup check, intermittent exceptions due to lack of privileges
• Oracle – Autoextensible files check, intermittent exceptions due to lack of privileges
• Oracle – Free extents check, intermittent exceptions due to lack of privileges
• Oracle – Tablespace free check, intermittent exceptions due to lack of privileges
• Oracle – Job Scheduling check, improved handling of large job names and multiple errors
• Oracle – Tablespace free space check, improved handling for ignored tablespaces
• Oracle – new version: Delete SYS.AUD$ data
• Postgres -new version: Session load
• DBW – handling of engine scripts with multiple versions
• DBW – Bugfix in task editor – save as new
  

Improvements

• Oracle – Adjusted history thresholds to a minimum of 14 days for jobs
• Oracle – Improved graphs Management, Better history for Logical IO
• Oracle – Improved graphs Management, Better history for Network throughput
• Oracle – Improved graphs Management, Better history for Transactions per sec
• DBW – sub/add function now has optional timeunit argument
• DBW – improvements to job template handling
• DBW – improvements to monitor/server socket handling
• DBW – improvements to the internal initialization sequence
• DBW – filtering dates in tables
• DBW – improved caching of management specifications on the monitor
• DBW – improved handling of Oracle RAC
• DBW – improved handling of Oracle Dataguard
• DBW – improved handling of service groupings
• DBW – improved handling of exhausted license
• DBW – improved property loading
• DBW – number alignment in tables
• DBW – improved default mail configuration
  

New features

• MySQL – new job: Innodb cluster status
• MySQL – new job: Innodb cluster switch
• MySQL – new job: Replica count
• MySQL – new Job: Replica delay
• MySQL – new Job: Replica state
• MySQL – New job for NDB cluster, NDB data node status
• MySQL – New job for NDB cluster, NDB data memory usage
• MS SQL Server – added Kerberos support
• MS SQL Server – new task: Database session load
• 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 – Adding ssh based jobs for AIX and Linux
• DBW- task parameter default value now available in fdl
• DBW – instance import now supports job templates
• DBW – added instance menu to status tables
• DBW – added ssh support
• DBW – added compacting of static property store
  

dbWatch Control Center (2021-10-19)

New features

• Basic job template support
• Added new Farm Maintenance views for Microsoft ERROR log statistics
• New job for MS SQLServer, “Database session load,” which collects session statistics per database
  

Bugfix

• Pie chart color rendering
• Fixed issues in PostgreSQL reconnect
  

Improvements

• Improved speed for Oracle connect
• More robust socket handling
• Cosmetic changes to the Domain Login dialog
• Server performance improvements
• Improved Internal views
  

Misc

• Removed backup statistics from Farm views
  

dbWatch Control Center (2021-09-09)

• Improvements to domain handling
• Improvements to network stability
• Improvements to FDL handling in multi-domain setups
• Improvements to eval license handling

• New dialog for initial domain setup
• New Login Dialog
• New E-Mail configuration dialog

• Added ‘Clone & Detach’ feature for charts and tables

• Bugfix: for Copy Cell
• Bugfix: You can now uninstall upgradable no-engine jobs
• Bugfix: Local reports for no engine jobs
• Bugfix: Missing labels on some charts
• Bugfix: Configuration backups
• Bugfix: Countless minor bugfixes

• 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
• Backup overview (for MS SQL Server) – Beta
• Maintenance overview (for MS SQL Server) – Beta

• Oracle Dataguard apply time, a new basic report added
• Oracle Dataguard archive sequence apply lag, a new basic report added
• Oracle Dataguard gap alert, a new basic report added
• Oracle Dataguard startup time, a new basic report added
• Oracle Dataguard transport time, a new basic report added
• Oracle Dataguard apply time, adjusted default schedule to run less frequent
• Oracle Dataguard archive sequence apply lag, adjusted default schedule to run less frequent
• Oracle Dataguard startup time, adjusted default schedule to run less frequent
• Oracle Dataguard transport time, adjusted default schedule to run less frequent
• Oracle Dataguard datafile status, adjusted default schedule to run less frequent
• MySQL/MariaDB, Improvements in engine scripts for improved cloud support
• Oracle DB Uptime, Fixes for report issues
• Postgres Locks held and statistics, Bugfix on job reinstall issues
• Postgres Transaction statistics, Bugfix on job reinstall issues

dbWatch Control Center (2021-05-28)

Download

Bugfixes

• Metadata storage fixed
• Improved stability in message routing
• Incorrect refresh in the Manage Jobs view
• Version handling when importing no-engine jobs
• Missing label in report charts
• Adding instances with MySQL 5.0 – 5.6 on AWS or on-premise could fail with privilege issues
• Oracle database network statistics improved housekeeping
• Server selection now works in the Extension view
  

Improvements

• Support for AlwaysOn cluster
• Added time topic for server
• Improved “Domain Login” dialog
• Improved “Connected users” view
• New “Internal Notes” views
• New “Internal engine files” views (MS SQL Server, Oracle)
• Can now “delete” auto-discovered instances
  

Known issues

• AlwaysOn
  • You can get an error the first time you execute the “AlwaysOn database backup alert” and “AlwaysOn transaction log backup alert.”
  • The databases in Availability groups are not shown in management.
  • You must select “Cluster” as a grouping in the tree. This selection is forgotten on Monitor restart.

dbWatch Control Center (2021-05-06)

Download

Bugfixes:

• Connection stability issues monitor/server
• Issues with job upgrade
• Issues in add instance wizard
• Issues in Connect/Disconnect to all instances
• Duplicates in upload resource view
• Sort order in the acknowledgment history view
• Fixed “Show error log,” for instance
• Stability issues in chat
• Lots of minor fixes in stability and user interface
  

Improvements

• Improved dialog for initial domain setup
• Improved installation wizard
• Added “busy” indicator in domain login dialogs
• Login on entering in domain login
• New version for MS SQL Server “Database growth rate (detailed)” job
• New version for MS SQL Server “Filegroups growth rate” job
• New version for MS SQL Server “Transaction log space usage” job
• New version for MS SQL Server “Database disk capacity” job
  

dbWatch Control Center (2021-04-23)

Improvements

• More user-friendly flow for initial installation
• Improved stability
• Improved Access control
  

Bugfix

• Generation of global reports
  

Limitations

• Multi-domain is not stable
• Postgres drivers can only support up to version 9.6 since the available driver only applies to 9.2.1003, which does not have SCRAM-SHA-256.
• dbWatch server on Linux and Ubuntu are not yet supported
• Same MySQL installation error as RC 3
• PostgreSQL unstable (Work in progress)
  

dbWatch Control Center RC 4.0

RC 4.0 focuses on UI stability and additional features from RC 3.0

New Features

• Recommended to install to a small environment with instances no more than 100 instances
• Upon installation, dbWatch will ask for the license file
• SMTP extensions for emails
• UI stability where the connection does not prematurely die
• Brent Ozar module.
• Farm Module Views are split into three separate files; this is a fix to RC3’s single instance view problems when there are more than 20 instances registered

Known Issues:

• Postgres drivers can only support up to version 9.6 since the available driver only applies to 9.2.1003, which does not have SCRAM-SHA-256.
• dbWatch server on Linux and Ubuntu are not yet supported
• Same MySQL installation error as RC 3
• Recovery options for MSSQL are only limited to SIMPLE recovery (FULL backup restore)
• In the “Add Instance” Wizard, UI locks the “NEXT” button when returning from the job installation process
• Limited Security Set-up – only admin credentials are available with six instances
• Bulk Installation is still riddled with bugs when installing databases

dbWatch Control Center RC 3.0

RC 3.0 integrates a few new features from RC 2.0

New Features

• Can support up to 100 databases for now; will keep on expanding to accommodate more
• Autodiscover feature
• dbWatch internal is added as a view

Known Issues:

• Connection dies after 30 minutes of no activity
• MySQL installation for version 8 and above encounters an error during installation
• dbWatch server on Linux and Ubuntu are not yet supported
• More than 20 instances will cause a bug for single instance views; you can still see the overview but clicking on an instance will
• No stress testing is done with multiple servers housing hundreds of databases
• In the “Add Instance” Wizard, UI locks the “NEXT” button when returning from the job installation process
• Limited Security Set-up – only admin credentials are available with six instances at max
• Bulk Installation is still riddled with bugs when installing databases

dbWatch Control Center RC 2.0

RC 2.0 is an improvement from RC 1.0 regarding UI stability and dbWatch server connection.

New Features

• Can support up to 100 databases for now; will keep on expanding to accommodate more
• Bulk Instance Installation
• Supports up to Postgres 12 and MySQL database engines
  

Known Issues:

• No comprehensive testing done with Sybase, MySQL, MariaDB, Ingres and Postgres
• dbWatch server on Linux not yet supported
• No stress testing is done with multiple servers housing hundreds of databases
• In the “Add Instance” Wizard, UI locks the “NEXT” button when returning from the job installation process
• Limited Security Set-up – only admin credentials are available with six instances at max
• Bulk Installation is still riddled with bugs when installing databases
  

dbWatch Control Center RC 1.0

Control Center takes your monitoring solutions to new heights. Similar to dbWatch 12.7, it covers all your monitoring needs.
More importantly, it builds on its functionality and user-friendly design with the following:

• Extensive dashboards and view to monitor and manage larger database server farms
• new and easy-to-use UI
• Expand the job list of dbWatch 12.7 monitoring solution for SQL and Oracle even further
• Supports Oracle 12, 18 and 19, and MSSQL 2012, 2014, 2017 (Mysql)
• Farm Data Language – an improved version of Dbwql
  

Tested and supported:

• Oracle 8, 9, 10, 11, 12, and 9; both standard and enterprise editions
• MSSQL for 2000, 2005, 2008, 2012, 2016, 2017, and 2019; both for Standard and Enterprise Editions
• dbWatch Server installed on Windows 10
  

Known Issues:

• No full testing done with Sybase, MySQL, MariaDB, Ingres and Postgres
• dbWatch server on Linux not yet supported
• Incoherent error detection, such as character limit that prompts error: illegal characters inputted
• No Max and Min hours of scheduling.
• Repeated configuration in installing jobs can produce bugs
• No stress testing done with multiple servers housing hundreds of databases
• In the “Add Instance” Wizard, UI locks the “NEXT” button when returning from the job installation process
• Limited Security setup – only admin credentials are available
• Stability Issues when connecting to several servers
  

← About dbWatch Control Center / Versions Summary →

Copyright © 2024 dbWatch AS