Released: Feb 12, 2025

February 2025 での更新項目

機能

• MS SQL Server - new job “Logins default database check”. This procedure performs two checks. “Sysadmin Logins Default Database Check” which verifies that all logins with sysadmin privileges have their default database set to master, and “Default Database Validity Check” which identifies logins with a default database that is either not online or does not exist. The results provide insights into potential misconfigurations that could impact login functionality or administrative best practices.
• Azure database - new job “Rebuild index”, a new maintenance job for rebuilding indexes on a single Azure database.
• DBW - FDL force function. Will flush and force a new resolving of a single FDL property.
• DBW - Job post FDL execution (for flushing properties).
• DBW (experimental) - USL scheduling and parameter handling.
• DBW (experimental) - USL from no engine jobs.
• DBW (experimental) - USL can now set metadata.
• DBW (experimental) - Non-database instances (target).
• Improvements:
  • All DBMS platforms – job "Instance restart alert" has been improved to handle negative restart times (which are not supposed to occur) by recalculating them.
  • Oracle – job "Tablespace free space", new parameter, query_timeout.
  • Oracle – job "SYS.AUD$ size", job has been improved to provide more descriptive feedback if the database instance is not in the OPEN state.
  • Oracle – Global report "Health check report for Oracle", presentations are generated according to the installed jobs, ensuring no errors occur if tables are missing from the dbWatch schema.
  • MS SQL Server – job "Page verify option" job has been improved to record changes made to a database’s PAGE_VERIFY setting. It includes details such as the time of the change and the old/new PAGE_VERIFY value.
  • MS SQL Server – job "SQL statistics" job has been improved to record missing index statistics. Additionally, the Farm view "SQL statistics job – execution statistics" has been extended to display the total number of missing indexes recorded and the timestamp of the most recent entry.
  • MS SQL Server – job "Update index statistics", added a new parameter which controls whether both column statistics and index statistics should be updated during the execution of the UPDATE STATISTICS operation.
  • MS SQL Server – job "Wait statistics". In this job, a clustered index was created on the historical table dbw_wait_stat_histr to reduce user_scans and improve query performance. This change aims to enhance the efficiency of data retrieval from the dbWatch history table.
  • MS SQL Server – job "Index usage statistics (all databases)". This job has been optimized to improve execution time in environments with a large number of databases (several hundred databases per instance). The improvements ensure more efficient performance and reduced runtime in such scenarios.
  • MS SQL Server – job "DBCC CHECKDB", improved exception handling.
  • MS SQL Server – job "Auto growth event collector" improved visualization of event data in the local report.
  • MS SQL Server – job "MS SQL Server patch status", added patch information from Microsoft Update Catalog up to January 2025 (patch CU30 2019 and CU17 2022).
  • PostgreSQL – Global report "Health check report for PostgreSQL", removed chapters for Vacuum and Analyze.
  • DBW – Can now have multiple menus from single table row.
  • DBW – Task autoupgrade more robust.
  • DBW – Resource compatibility resolving optimization.
  • DBW – Manage Job Templates "loading" marking.
  • DBW – Web stability.
  • DBW – Web access tokens.
  • CCC – Can now work through Cloud Router.
  • CCC – FDL engine more robust.
  • DBW (experimental) – Editor image view zoom/scroll.
  • DBW (experimental) – Target now part of security and domain layout.

不具合の修正

• CCC: Certificate refresh issue. Privilege changes where not reflected in the CCC node certificate.
• Oracle:
  • Job “RMAN backup status”. Job fails during execution with “ORA-01403: no data found” (new version 2.66).
  • Job “Buffer cache statistics” upgrade to version 2.3 failed in RAC environments.
  • Job “Instance alert log” missing sys.dbw$dbgalertext view and select privileges for dbwatch database user. Now using …. view.
• MS SQL Server:
  • Job “Database growth rate (aggregated)”. This job failed during installation on database instances with case-sensitive collation.
  • Job “Query Store status” exception with cursors on instances with multiple character sets (collations).
  • Job “Autogrowth settings” exception with cursors on instances with multiple character sets (collations).
  • Job “Index usage statistics (all databases)” exception with cursors on instances with multiple character sets (collations).
  • Job “Update index statistics” exception with cursors on instances with multiple character sets (collations).
  • Agresso jobs support now database in AlwaysOn cluster.
  • Create local database on existing instance in AlwaysOn cluster.
• DBW:
  • Graphical bug in the SQL Worksheet that caused a lot of CPU usage while waiting for result.
  • Properties import flush bug. Properties that were imported could take a while to appear.
  • No engine job import caching issue. Imported jobs were not visible for up to minute after import.
  • Delete node “ghost” issue. Nodes that were deleted from the domain, still appeared on some Monitors as a disconnected node.