SQLWATCH 2.5 is now available
- Fixed an issue where table utilisation was not being collected for databases other than SQLWATCH. As all tables are being processed now, the execution time for
[dbo].[usp_sqlwatch_logger_disk_utilisation_table]
may increase considerably. Please test it in your environment first.
In case you have missed 2.4 update, there have been a lot of changes:
- 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.
Recent Posts
Marcin Gminski2023-03-28T22:07:01+01:00
Want to learn about SQLWATCH?
Marcin Gminski2023-03-28T22:07:01+01:0028th March 2023|0 Comments
Marcin Gminski2022-10-06T15:32:56+01:00
SQLWATCH 4.4
Marcin Gminski2022-10-06T15:32:56+01:006th October 2022|0 Comments
Marcin Gminski2023-07-06T23:15:07+01:00
T-SQL Tuesday #147 – SQL Server Upgrade Strategies
Marcin Gminski2023-07-06T23:15:07+01:008th February 2022|0 Comments
Marcin Gminski2022-03-25T12:40:05+00:00
Should we run SQL Server on the default port 1433
Marcin Gminski2022-03-25T12:40:05+00:007th February 2022|3 Comments
Marcin Gminski2022-01-01T18:28:43+00:00
Happy New Year!
Marcin Gminski2022-01-01T18:28:43+00:001st January 2022|0 Comments
Marcin Gminski2021-12-02T23:15:16+00:00
I am a Microsoft MVP!
Marcin Gminski2021-12-02T23:15:16+00:002nd December 2021|10 Comments