• Many bug fixes and improvements behind the scenes.
• ERRORLOG collection. Define keywords you'd like to monitor in [dbo].[sqlwatch_config_include_errorlog_keywords]
• sys.configuration audit to track configuration changes.
• Changes to the initial SQLWATCH configuration:
  • INFO messages will NOT be logged by default to reduce the size of the [dbo].[sqlwatch_app_log] table.
  • [dbo].[sqlwatch_app_log] retention changed to 7 days
  • batched up [dbo].[sqlwatch_app_log] retention to prevent blowing up the transaction log
• Initial integration with DBACHECKS to be able to show failed checks on the SQLWATCH dashboard.
• Fixed trends job that was spilling to tempdb and blowing it up.
• Improved date hierarchy on the dashboard that now allows selecting year->month->day->hour->minute
• Tested with Power BI May 2020 release.