As a DBA you regularly schedule backups you might have regular full backups, incremental backups and hopefully regular backups. Over time you might realize that your error log is not longer filled with errors, but instead a majority of your …
Quick Scan Report – Logs Flooded with Backup Messages Read more »
Have you tried out Database Health Monitor and the Quick Scan report? The Quick Scan report does a quick check (sometimes not so quick depending on the system). It checks for server best practice recommendations, and security and performance recommendations …
With over 2000 downloads since the last updated to Database Health Monitor, I figured it was time to get another release of the product out. New Features in 2.6 Added a Job Schedule instance level report. Added an option on …
Database Health Monitor October 2017 Version Released Today Read more »
Today I had the opportunity to complete and launch the February 2017 version of Database Health Monitor. I hope you like the latest version. Here are the Release Notes: Version 2.5 Release Notes – February 2017. Version 2.5 is the …
February 2017 Release of Database Health Monitor Read more »
Today I released the latest update to Database Health Monitor. Version 2.4.2. It has been about a two weeks since version 2.4.1 release and version 2.4.2 has a few new features, and a couple bug fixes. Here is a preview of …
Database Health Monitor Version 2.4.2 Released Today Read more »
The check for excessive sysmaintplan_logdetail has be added to the Database Health Monitor – Quick Scan Report. If you haven’t had a maintenance plan to clean up maintenance plan history, it can grow excessively over time. I recently worked on a …
The check for Cost Threshold for Parallelism check has be added to the Database Health Monitor – Quick Scan Report. The Cost Threshold For Parallelism setting in SQL Server controls the level at which the query optimizer decides to have a query …
With the updated release of Database Health Monitor yesterday, here is the updated list of documentation on the Quick Scan Report. All of the following (plus a few more) are checked from the Database Health Monitor Quick Scan report. The …
The check for MAX DEGREE OF PARALLELISM has be added to the Database Health Monitor – Quick Scan Report. The max degree of parallelism setting in SQL Server is used to control the maximum number parallel threads available to process your …
The Quick Scan report in Database Health Monitor detects when you are performing SQL Server backups without compression, when the compression option is available. This applies to Full backups, Transaction log backups and Differential backups. Not using compressed backups? Why not? …