Category: Database Health

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

Posted in Database Health 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

Posted in Database Health Tagged with: , , , , ,

Database Health Monitor – Version 2.3 Released

With over 7500 downloads worldwide to date, I have just released the next installment of the FREE Database Health Monitor application. Here what one person had to say about it “Excellent – It’s the first tool I open every morning

Posted in Database Health Tagged with: , , , , , , ,

Database Health Version 2.2 Released Today

Today I have the pleasure of releasing the next version of the Database Health Monitor application. Currently at version 2.2, I have been working on this since 2011, and I have introduced some new features in the latest version. Visit

Posted in Database Health 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?

Posted in Database Health Tagged with: , , , , , ,

Featured Report: Backup Status Report

As part of the Database Health Monitor version 2.1 release there were many new report includes, one of those was the backup status report. A quick way to page through all of your SQL Servers and check on the status

Posted in Database Health, DBA Tagged with: , ,

Database Health Monitor Version 2.1 coming soon

In the next week or two, I will be releasing version 2.1 of the Database Health Monitor application. I am just going through the final testing process now to get it ready for general release. There are a number of

Posted in Database Health Tagged with: , , , , ,

Silencing Backup Messages with Trace Flag 3226

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

Posted in Database Health Tagged with: , , , , , ,

Understanding your Wait Statistics

SQL Server Performance Tuning Tips – Wait Statistics Wait statistics are one of commonly overlooked ways to quickly find out what is causing your SQL Server to be slow. One of the reasons that they are commonly overlooked is that

Posted in Database Health, Performance, Server Health Tagged with: , , , ,

Database Health Monitor – Historic Waits

With the recent release of Database Health Monitor Version 2.0 I have decided to focus on of blogging about the features and benefits of the Database Health Monitor application. There are some incredibly valuable features that are often overlooked. The

Posted in Database Health Tagged with: , , , , , , ,