Changelog

SQLWATCH v2.0

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/

SQLWATCH-2.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.

SQLWATCH-2.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.

SQLWATCH-v1.3.3

  • Performance tweaks in [dbo].[ufn_time_intervals]

SQLWATCH-v1.3.20

  • [fixed] issue #47

  • [added] interrogate system_health extended event session to get information about long waits including query text, workers and long io requests.
  • [added] new snapshot (6) for query text with default 3-day retention
  • [added] new performance dashboard with lots of new tabs: Query statistics, memory, database performance, logical file performance, logical disk performance and generic performance counter analyser

  • [removed] dacpac from branches. these are binary files causing merge problems. dacpacs are now available in releases.

v.1.2.6841.38712 (2018-09-24)

  • [fixes] #52 hardcoded database name in one of the job steps breaking deployment via dbatools.io
  • [fixes] #53 missing snapshot_type_id = 3 causing PK violation.

v1.1.6833.36316 (2018-09-17)

  • [added] new PowerBI dashboard to monitor disk utilisation
  • [added] Win32_Volume logging via PowerShell
  • [added] [dbo].[ufn_time_intervals] to address poor performance of time interval generation
  • [removed] setup.sql as no longer supported
  • [fixed] sp_spaceused logging pre SQL2016 (the @oneresultset problem)

v1.0 Initial release