Warning
If you are upgrading to this version and have no data compression enabled, the upgrade may take a long time because data compression is enabled by default. The compression only applies to the logger tables, so if you have compression enabled, only logger tables will remain compressed, and other tables will be reverted to uncompressed.

Contributors

@marcingminski

Changes

• Bump version to 4.8 (#472 by @marcingminski)

New Features

• Enabled Page Compression by Default (#473 by @marcingminski)

Contributors

@marcingminski

Changes

• Version bump to 4.7 (#469 by @marcingminski)

Bug Fixes

• Fix #465 (#471 by @marcingminski)

Contributors

@j-dc and @marcingminski

Changes

• Fix - correct number of rows per table for tables with multiple parti… (#468 by @j-dc)

Bug Fixes

• Fix #444 (#464 by @marcingminski)

Maintenance

• Fix #444 (#464 by @marcingminski)
• Version bump to 4.6 (#463 by @marcingminski)

Contributors

@marcingminski

Changes

Maintenance

• Version bump to 4.5 (#460 by @marcingminski)
• Remove CLR (#459 by @marcingminski)
• Remove CLR (#458 by @marcingminski)
• Remove SSIS (#457 by @marcingminski)

Contributors

@OliverUweHahn, @ben-thul, @kekcjkee, @marcingminski and @pluim003

Changes

• Fix #410 (#411 by @kekcjkee)

Bug Fixes

• Fix 417 (#456 by @marcingminski)
• fix #417 (#454 by @marcingminski)
• #403 - Performance Patch (#450 by @OliverUweHahn)
• Fix #437 (#440 by @pluim003)

Maintenance

• Update build to include dashboard files (#453 by @marcingminski)
• Version bump to 4.4 (#452 by @marcingminski)
• Fixed minor typo, formatting change in README.md (#447 by @ben-thul)
• Minor grammar change (#446 by @ben-thul)
• Remove old PBI dashboard (#405 by @marcingminski)

Contributors

@MCTSQL, @kekcjkee, @marcingminski and @steffenengelhamburg

Changes

New Features

• #378 Replace localhost with @@ServerName (#380 by @steffenengelhamburg)

Bug Fixes

• Fixed blockers tab in Power BI dashboard (#404 by @marcingminski)
• Fixed sp_WhoIsActive time collection criteria (#400 by @MCTSQL)
• Fixed internal-config logger (#390 by @kekcjkee)
• Fixed Cheks action auto-expansion in usp_sqlwatch_internal_expand_checks (#386 by @kekcjkee)
• Fixed Links for the Checks Panel in Grafana Dashboards (#384 by @steffenengelhamburg)

Maintenance

• Remove old PBI dashboard (#405 by @marcingminski)
• Removed tester database as all tests managed by Pester (#376 by @marcingminski)
• Remove Sonar Cloud (#389 by @marcingminski)
• Update FUNDING.yml (#388 by @marcingminski)

Contributors

@marcingminski and @TArmstrong24

New Features

• More tweaks to Query Problems XES (#364 by @marcingminski)
• Reenabled XES to capture problematic queries (#362 by @marcingminski)
• XES to log SQLWATCH own performance and problems (#361 by @marcingminski)
• Add ability to capture ERROLOG records based on two keywords. (!) (#359 by @marcingminski)
• New tests for SqlWatchImport.exe (#352 by @marcingminski)
• More Pester tests and tweaks (#346 by @marcingminski)
• Improved Performance of XES collectors (#345 by @marcingminski)

Bug Fixes

• Fix Grafana panel reference in alternative charts (#371 by @marcingminski)
• Fix 354 (#369, #370 by @marcingminski)
• Fixed expanding checks on central repository (#368 by @marcingminski)
• Brought back carriage return when clearing SQL Text (#367 by @marcingminski)
• Fixed data purge failure introduced in version 4.1 (#366 by @marcingminski)
• Fixed Wait Events Grafana Dashboard (#365 by @marcingminski)
• Fixed XES Event Count (#358 by @marcingminski)
• Fix casing (#351 by @marcingminski)
• Fixed missing query details in report views and Grafana dashboard. (#347 by @TArmstrong24)
• Improved Performance of XES collectors (#345 by @marcingminski)
• Fixed usp_sqlwatch_internal_add_procedure not being invoked via Broker. Fix #342 (#343 by @TArmstrong24)

Maintenance

• Removed old and now irrelevant helper procedures (#360 by @marcingminski)
• Fix casing (#351 by @marcingminski)
• Version bump to 4.2 (#340 by @marcingminski)
• Update release-drafter.yml (#339 by @marcingminski)

Contributors

@marcingminski and @TArmstrong24

Features

• Change to parse job name and replace binary value with Job Name (#313 by @marcingminski)
• Added default ERRORLOG keywords that are worth monitoring. (#319 by @marcingminski)
• Improvements to the test suite (#323 by @marcingminski)
  • Tweaks to the test suite (#330 by @marcingminski)
  • Feature tests (#317 by @marcingminski)
  • Feature tests (#316 by @marcingminski)
  • Added separate database for automated tests (#321 by @marcingminski)
  • Add instance name to the Test Suite Name for better visibility on the dashboard (#332 by @marcingminski)
  • Add schema validation tests (#331 by @marcingminski)

Bug Fixes

• Fixed transaction count error in usp_sqlwatch_logger_whoisactive (#336 by @marcingminski)
• Fixed usp_sqlwatch_internal_get_query_plans PK violation (#334 by @marcingminski)
• Fixed usp_sqlwatch_logger_query_stats referencing the wrong object (#333 by @marcingminski)
• Fixed collation issue in usp_sqlwatch_logger_performance (#329 by @marcingminski)
• Fixed Bug SQL Re-Compilations/sec counter in Grafana (#328 by @TArmstrong24)
• Fixed PK violation caused by duplicate records in the ERRORLO… (#318 by @marcingminski)

Maintenance

• Update documentation to include data source creation via API (#314 by @marcingminski)
• Update README.md (#312 by @marcingminski)
• Update release-drafter.yml (#311 by @marcingminski)
• Update release-drafter.yml (#310 by @marcingminski)

This release brings several bug fixes, improvements and new features. Following our naming convention, some of those improvements and fixes introduced breaking changes which means we must bump the version to 4.x as it impossible to upgrade from 3.x without migration scripts. If you are on 3.x or earlier version, you must deploy this release as a new database.

This release also brings several improvements to the way release notes are published and to the internal testing process. Hopefully from now on we should be able to release more often and with better release notes.

New Features

• Improved Backup Checks to be AG aware #289 #296 (#299 by @steffenengelhamburg)
• Added Long Queries to Grafana Dashboard (155efc7, ac00127 by @marcingminski)
• Improved way we store execution plans #297 #286 #295 (827db55, #291 by @marcingminski)
• Added ability to collect performance counters via CLR. This is experimental for now and not enabled and does not require CLR to be enabled unless you want to use this functionality. More details in #256 (1870cad, 58bd284, 98a2c9d, 2c1849e, 758c1c2 by @marcingminski)
• Ability to process checks on the central repository (#250 by @marcingminski)
• Query Problem XES disabled by default as does not yet work on 2012 (8556fcb, 00cc9bd, 6812f0f, b5b0ca4 by @marcingminski)
• New Grafana panel to show current and historical blocking chains (6b0afe3 by @marcingminski)
• Customisable baselines allowing to "freeze" data and prevent it from being deleted by the retention. Baselines can now be used in Checks as they can check for deviation from the baseline as well as deviation from the set value. Future releases will introduce changes to the Dashboards to be able to show them (7abde20, 03a9ebb, d6ef25e, 9e61e28, 942dd26, 72faa1a by @marcingminski)
• New collector: Exec Requests and Sessions (6be412a, 479aebf, 9a31d9d, 9c1202e, ba8d451 by @marcingminski)
• Ability to invoke collection via Service Broker. This functionality is not yet enabled by default. To migrate from Agent Jobs to Broker run exec dbo.usp_sqlwatch_internal_migrate_jobs_to_queues. There are several benefits to use broker as explained in my post https://sqlwatch.io/blog/announcements/were-moving-to-queues/ (#246 by @marcingminski)

Improvements

• Minor improvements to SqlWatchImporter.exe (#305 by @DavidBetteridge)
• Fix #286. I redesigned the way we store plans to make it more storage… (#290 by @marcingminski)
• Change SQLWATCH_long_queries dispatch latency from 5 seconds to 30 seconds as there is no need for instant collection of long running queries (39461f6 by @marcingminski )
• Change: Filter Name: SqlInstance Query in Azure Dashboards (#233 by @steffenengelhamburg)
• Performance tweaks and improvements to the blocking chains collector (d9fb345, 6aadfe3, 6874093, bcaeff5 by @marcingminski)
• Changed default blocking threshold to 5 seconds (262453c by @marcingminski)
• Change dispatch of SQLWATCH_blockers XES to 1 second to be able to capture chains as soon as they appear to show on Dashboard (35553e1 by @marcingminski)
• Added condition to check for SQL Agent when deploying SQLWATCH so if the agent is stopped, we will not attempt to deploy agent jobs as it would fail. They can be deployed later via stored procedure (cf87787 by @marcingminski)
• Tweaks to Grafana chart colours (66e7cae by @marcingminski)
• Performance improvements to Grafana Dashboards to reduce number of SQL Calls (291a86d, 0aa2356, 60900c8, a5bc3ef, c795567 by @marcingminski )
• Performance improvement to reduce re-compilation rates (b4e98c5, 71afc67 by @marcingminski)
• More intelligent index collect that should now collect index stats based on their age and configurable batch, giving better collection performance (25036d3 by @marcingminski)
• Performance improvements to the performance collector (c42dd23 by @marcingminski)
• Performance improvement to wait stats collector (b45e09b by @marcingminski)
• Performance improvement to only collect Ring Buffer data when there are new values rather than every 10 seconds (58141c6 by @marcingminski)

Bug Fixes

• Fix #303 (#304 by @marcingminski)
• Fix #294 reduced xes file size to 5MB (#298 by @marcingminski)
• Fix #287. Changed FK to reference correct table (#293 by @marcingminski)
• Fix #285. Fixed typo in the object name (#292 by @marcingminski)
• Fix #275 to handle divide by zero when delta seconds is null or zero (#282 by @marcingminski)
• Fix #266 (#283 by @marcingminski)
• fix #270 to handle agent jobs for default SQLWATCH installation (#281 by @marcingminski)
• Bug: Script.PostDeployment-CreateDefaultChecks.sql (#232 by @steffenengelhamburg)
• Fixed XES to work on 2012 and 2014 (#259 by @marcingminski)
• Fix #264
• Fixed CPU utilisation not being collected on SQL Standard (#261 by @marcingminski)
• Fixed issue where Ring Buffer values were hardcoded (488c7a4 by @marcingminski)
• Fixed collation in Post Deploy script (0954c61 by @marcingminski)
• Fixed ufn_sqlwatch_convert_datetimeoffset_to_local to make it work on 2012
• Fix #254
• Fix #253
• Fix #248
• Fix #247
• Fix #242
• Fix #244
• Fixed PK violation in usp_sqlwatch_logger_system_configuration #200 (#234 by @SiavashGolchoobian)
• Fixed data types in usp_sqlwatch_logger_disk_utilisation_os_volume (9b53be0 by @marcingminski)
• Fixed an issue where explicit data conversion was applied to a PK field that in rare cases could lead to mismatch in PK (e00d0e7 by @marcingminski)
• Fixed lock timeouts in usp_sqlwatch_internal_insert_header (66dad64 by @marcingminski)
• Redesigned trend collection that should address issue #215 (0654713, d4cd478 by @marcingminski)
• Fix #306 to address null tasks (#308 by @marcingminski)
• Fixed CHECK_ERROR count (https://github.com/ma...

SQLWATCH 3.0

• New Real-Time Grafana Dashboards
• New .NET C# Console Application to import data from remote instances into the central repository
• New and improved, more flexible checks and templates
• New data collectors (procedure and query stats and availability groups)
• Performance collection increased to every 10 seconds.
• Fixed and tweaked Extended Event Sessions - please drop existing XES before installing
• Unified wait stat exclusion for XES collectors
• Bug Fixes and Performance Improvements
• Add ability to deploy multiple SQLWATCH databases and corresponding jobs on a single instance