Skip to content

SQLWATCH 2.0
Compare
Choose a tag to compare
@marcingminski marcingminski released this 19 Oct 18:33
2_0
2120a80

Due to a bug creating duplicate table records, which creates a Cartesian product and causes exponential growth of downstream objects such as index stats and histogram I decided to pull this release until fixed as it could have some serious storage consequences. Apologies. Coding is hard.

Proud to announce the long overdue 2.0 release:

  • Updated Dashboard
  • Central repository with SSIS to pull data from remote instances
  • New collectors: os_schedulers, extended events and SQL Agent history
  • Unified and normalised schema
  • Bug fixes
  • UTC dates
  • New configuration procedures
    Documentation can be found at https://docs.sqlwatch.io/

v2.0-beta6.2:
A lot and not a lot of changes.

  • redesigned schema to accommodate server name as part of Primary Key for the central repository

That's it. PK changed in every table and procedure. Looks like small change but with a huge impact.

v2.0-beta5:

  • [fixed] handle collation match in job deployment logic
  • [fixed] address INT2 wait_stats overflow on busy systems
  • [fixed] added XES collection steps to to the performance collector job
  • [fixed] handling of empty wait_info recordset for default system_health session
  • [fixed] improved deployment of multi-step jobs
  • [fixed] added index stats collector step to the index collector job
  • [change] whoisactive job is now deployed disabled by default
  • [new feature] Added default filter on whoisactive collector to only collect sessions lasting over 15 seconds. This is configurable as a parameter in the procedure.
Assets 2
Loading