New in dbWatch 12.6.16

21. okt 2019 – ( Download )

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 – ( Download )

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 – ( Download )

Bugfix

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

New in dbWatch 12.6.10

01. jul 2019 – ( Download )

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 – ( Download )

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 – ( Download )

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 – ( Download )

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 – ( Download )

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 – ( Download )

Bugfix

  • Issues for Oracle install

Improvements

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

New in dbWatch 12.6.2

22. february 2019 – ( Download )

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 – ( Download )

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 – ( Download )

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 / Overview of dbWatch →

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