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? Benefits of compressed backups Faster backup time Faster restore time Less I/O at backup and restore time Since you are …
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 of backups. Here is an example of the backup status report showing a database that hasn’t had any recent backups, …
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 free to use on more than one server. The answer is yes indeed, this is a totally free application to …
Database Health Monitor version 2.1 Just Released Read more »
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 new features that have been requested since the release of version 2.0 that will be coming out in version 2.1. …
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 error log is filled with backup messages. “Backup Database successfully … “, “Database backed up…”, “Log was backed up”. This …
SQL Server Performance Tuning Tips – Wait Statistics Wait statistics are commonly overlooked ways to quickly find out what is causing your SQL Server to be slow. One of the reasons is it’s difficult to see how they are trending over time. >>> It is not difficult with a monitoring tool. <<< When someone reports a slow database yesterday at …
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 purpose of this blog series is to present some of the features of the product. If you haven’t tried Database …
After 4 years of beta and 5500 installs of Database Health Monitor beta releases in the last 2 years, Database Health Monitor version 2 is finally complete. It is no longer in beta. If you are curious about the history of Database Health Monitor, take a look at my post from earlier in the week. Here is a preview of …
Over the last 4 years I have been working on the Database Health Monitor. I am about a week away from releasing Version 2, which will finally be out of the beta process. In preparation for the release I am sharing some of the history of this program. In 2011 version 1 was released as a set of my favorite …
It has been a long day, but I was able to get the latest Beta release of Database Health Monitor out. If you haven’t heard of Database Health Monitor monitor before, here is the quick rundown. It is a set of performance monitoring reports and tools to help you get more performance out of your SQL Server. Database Health Monitor is a project that …
Database Health Monitor Beta 10.2 Released Today Read more »