Sqlwatch Versions Save

SQL Server Performance Monitor

4.8

1 year ago

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)

4.7

1 year ago

Contributors

@marcingminski

Changes

Version bump to 4.7 (#469 by @marcingminski)

Bug Fixes

Fix #465 (#471 by @marcingminski)

4.6

1 year ago

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)

4.5

1 year ago

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)

4.4

1 year ago

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)

4.3

2 years ago

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)

4.2

3 years ago

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)

4.1

3 years ago

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)

4.0

3 years ago

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 (https://github.com/marcingminski/sqlwatch/commit/155efc7ea27f7bef14d1ebfbda330f13f1d42d41, https://github.com/marcingminski/sqlwatch/commit/ac00127fc8227a3ccd22b73f2cc5549d951c3ed9 by @marcingminski)
Improved way we store execution plans #297 #286 #295 (https://github.com/marcingminski/sqlwatch/commit/827db55f4d36d109022375c3099475649349a01b, #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 (https://github.com/marcingminski/sqlwatch/commit/1870cadee01006ca2fb9313e1dadc03fc46adace, https://github.com/marcingminski/sqlwatch/commit/58bd2844f96125925ba556b71b5654f735f48100, https://github.com/marcingminski/sqlwatch/commit/98a2c9ded63d5e9a3d14919db447eba78befc6f7, https://github.com/marcingminski/sqlwatch/commit/2c1849e8f2b19d260f3866e53ad6b95138e5293b, https://github.com/marcingminski/sqlwatch/commit/758c1c2df3654778ebd95b32491c6c4ac2b82279 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 (https://github.com/marcingminski/sqlwatch/commit/8556fcb3f0a76635b87462af9f8610a94c637157, https://github.com/marcingminski/sqlwatch/commit/00cc9bd9949189418dfaa9a77a1f9775e3fe64f7, https://github.com/marcingminski/sqlwatch/commit/6812f0ffdb7ebc6a16d7857eea80d5309abaadcd, https://github.com/marcingminski/sqlwatch/commit/b5b0ca44a4c5bf5984566050249a78f65a84db3b by @marcingminski)
New Grafana panel to show current and historical blocking chains (https://github.com/marcingminski/sqlwatch/commit/6b0afe3fa8057be31e9082f7f2b85e6fba5a2883 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 (https://github.com/marcingminski/sqlwatch/commit/7abde20475ffa2cf500c8f1032087e166d596c58, https://github.com/marcingminski/sqlwatch/commit/03a9ebb516a6c76b7b55aaf358054b5a3af0bd21, https://github.com/marcingminski/sqlwatch/commit/d6ef25ec975a288f0b6ac0bd0e693a72ab2f5c19, https://github.com/marcingminski/sqlwatch/commit/9e61e2836591ec3af78338a3a8cdedf24b597f1c, https://github.com/marcingminski/sqlwatch/commit/942dd26125394efcdcfa5074a3cbbe794552c7d9, https://github.com/marcingminski/sqlwatch/commit/72faa1add2d8bff6d3216e13059ef0b5b150903f by @marcingminski)
New collector: Exec Requests and Sessions (https://github.com/marcingminski/sqlwatch/commit/6be412ac3bed901e44ae7c3c272531e66a9ddd48, https://github.com/marcingminski/sqlwatch/commit/479aebfdb9a340acf40a2504ba33b86b4b4d9718, https://github.com/marcingminski/sqlwatch/commit/9a31d9deeb3b80cb84390f7db999e326cc73d762, https://github.com/marcingminski/sqlwatch/commit/9c1202ef2192dd429d4a6ef2977b07886fe39ff6, https://github.com/marcingminski/sqlwatch/commit/ba8d451e1e261acc12f8c33b469df7acbf32a7ec 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 (https://github.com/marcingminski/sqlwatch/commit/39461f6fa6b746419535b4a3b1ccdffa172e8a4b by @marcingminski )
Change: Filter Name: SqlInstance Query in Azure Dashboards (#233 by @steffenengelhamburg)
Performance tweaks and improvements to the blocking chains collector (https://github.com/marcingminski/sqlwatch/commit/d9fb3457a3673d32df4f6776d516a1f2617a207e, https://github.com/marcingminski/sqlwatch/commit/6aadfe3b9b4bfc17f3dec50fae2acdb54b59872, https://github.com/marcingminski/sqlwatch/commit/68740934276060037ccfedf5a7a5d3a7fc3ed1c6, https://github.com/marcingminski/sqlwatch/commit/bcaeff5af6b8fba5bde55b85493c976cf405d46d by @marcingminski)
Changed default blocking threshold to 5 seconds (https://github.com/marcingminski/sqlwatch/commit/262453c462f46c5cd19ee496df3e4865d7a1814e 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 (https://github.com/marcingminski/sqlwatch/commit/35553e1d2d237c683e44eb5892e619e08dd59721 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 (https://github.com/marcingminski/sqlwatch/commit/cf87787a26830177211e756ba3568d236ff641a8 by @marcingminski)
Tweaks to Grafana chart colours (https://github.com/marcingminski/sqlwatch/commit/66e7caee6317f92cee06268d5f48a58d66728478 by @marcingminski)
Performance improvements to Grafana Dashboards to reduce number of SQL Calls (https://github.com/marcingminski/sqlwatch/commit/291a86d75277f194d91cc542e4a592e0e44b69bf, https://github.com/marcingminski/sqlwatch/commit/0aa2356f025f6bc6338223b193866bf23bf39f44, https://github.com/marcingminski/sqlwatch/commit/60900c84d24daea1e95f720ad17870d88ecc481b, https://github.com/marcingminski/sqlwatch/commit/a5bc3ef4f36b7894894d600479047a4dc9b47ead, https://github.com/marcingminski/sqlwatch/commit/c7955674c48325731652689aea12adf307424f85 by @marcingminski )
Performance improvement to reduce re-compilation rates (https://github.com/marcingminski/sqlwatch/commit/b4e98c5b9d3fe911d67d6d1510dd49670095d8c5, https://github.com/marcingminski/sqlwatch/commit/71afc6760864bfe072ae0623bfa3cc78ad7a1a6a by @marcingminski)
More intelligent index collect that should now collect index stats based on their age and configurable batch, giving better collection performance (https://github.com/marcingminski/sqlwatch/commit/25036d3bca8aca8b35c999aae41d5bac35642a38 by @marcingminski)
Performance improvements to the performance collector (https://github.com/marcingminski/sqlwatch/commit/c42dd239e0f3d3337af71c5f5ca64eb5957cd2c9 by @marcingminski)
Performance improvement to wait stats collector (https://github.com/marcingminski/sqlwatch/commit/b45e09b0d6f00ee7610beb88943f61fd86a613a0 by @marcingminski)
Performance improvement to only collect Ring Buffer data when there are new values rather than every 10 seconds (https://github.com/marcingminski/sqlwatch/commit/58141c6d196d61c2071aeaa46a53d32d1237b4b7 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 (https://github.com/marcingminski/sqlwatch/commit/488c7a4a85a8231142c5b08620fac24f62f2dbca by @marcingminski)
Fixed collation in Post Deploy script (https://github.com/marcingminski/sqlwatch/commit/0954c61919decb236218983a95f62a7a8d4380dc 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 (https://github.com/marcingminski/sqlwatch/commit/9b53be04b7d842073e957fb8825940d4ae5f663e 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 (https://github.com/marcingminski/sqlwatch/commit/e00d0e76f905aec6bcf278167d1be5d7ebcfe5bb by @marcingminski)
Fixed lock timeouts in usp_sqlwatch_internal_insert_header (https://github.com/marcingminski/sqlwatch/commit/66dad64257454d7f3bd04c8443a93866aacd9437 by @marcingminski)
Redesigned trend collection that should address issue #215 (https://github.com/marcingminski/sqlwatch/commit/065471315961fb59fd10aefc872376436af6f454, https://github.com/marcingminski/sqlwatch/commit/d4cd4780a7cade9cfb214ca1f4c44c97cfe1bc11 by @marcingminski)
Fix #306 to address null tasks (#308 by @marcingminski)
Fixed CHECK_ERROR count (https://github.com/marcingminski/sqlwatch/commit/01ea9ab3eb3c3fa9746ff71788811c717334c2c4 by @marcingminski)
Fixed counters with multiple instances not being aggregated correctly (https://github.com/marcingminski/sqlwatch/commit/0a1511ed2cbc0df364502f3d007c152f9e0ecc4d, by @marcingminski)

Maintenance

fixed typos (#280 by @marcingminski)
added config for capital MD extension (#279 by @marcingminski)
Guidelines 1 (#278 by @marcingminski)
added guidelines to satisfy automated release notes and testing (#277 by @marcingminski)
Readme 1 (#276 by @marcingminski)
update codacy badge (#273 by @marcingminski)
Update README.md (#272 by @marcingminski)
Add a Codacy badge to README.md (#271 by @codacy-badger)
Main (#267 by @marcingminski)
corrected some casing problems (#265 by @chrgraefe)
Tweaks to build scripts (https://github.com/marcingminski/sqlwatch/commit/2dc9b2a8332271acf37580cc77ee9fd3a0dbccfd by @marcingminski)
updated docs (https://github.com/marcingminski/sqlwatch/commit/76cdf5ecc8fa2258abda3406bc7cc12aad6867bf, https://github.com/marcingminski/sqlwatch/commit/6e2fdea3f1705f20fc2125bc080bae1846e9a05e, https://github.com/marcingminski/sqlwatch/commit/89c3aaf29ac89fbc9e8a68450fdc13e18061f994 by @marcingminski)

3.0

3 years ago

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