Tag: Quick Scan Report

Database Health Monitor October 2017 Version Released Today

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

Tagged with: , , , , , , ,

February 2017 Release of Database Health Monitor

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

Tagged with: , , , , , , ,

Database Health Monitor Version 2.4.2 Released Today

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

Tagged with: , , , , , , ,

SQL Server – sysmaintplan_logdetail

The check for excessive sysmaintplan_logdetail has be added to the Database Health MonitorQuick 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

Tagged with: , , , ,

SQL Server – Cost Threshold For Parallelism

The check for Cost Threshold for Parallelism check has be added to the Database Health MonitorQuick Scan Report. The Cost Threshold For Parallelism setting in SQL Server controls the level at which the query optimizer decides to have a query

Tagged with: , , , ,

Database Health Monitor Quick Scan Report

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

Tagged with: , ,

SQL Server MAX DEGREE OF PARALLELISM

The check for MAX DEGREE OF PARALLELISM has be added to the Database Health MonitorQuick Scan Report. The max degree of parallelism setting in SQL Server is used to control the maximum number parallel threads available to process your

Tagged with: , , , , ,

Using SQL Server Compressed Backups

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?

Tagged with: , , , , , ,

Max Server Memory – SQL Server

Max Server Memory Setting Explained If you have more memory than your database and applications on the SQL Server will ever use than this is not a problem, but when you run into memory constraints this setting is much more

Tagged with: , , , , , , ,

Database Health Monitor version 2.1 Just Released

I have just released version 2.1 of Database Health Monitor, this release involved 2 months of development since version 2.0 was released in July. People often times ask me if this is free, or free to use in production, or

Tagged with: , , , , , , ,
Top