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.