What kind of load does the historic monitoring put on the SQL Server? It is my opinion that the historic wait monitoring is perhaps one of the most valuable features in Database Health Monitor. You can use it to see …
Database Health Monitor – Historic Wait Monitoring Read more »
The team at Stedman Solutions, LLC (Steve, Bill, Derrick, and George) offer a variety of services, but one that I particularly enjoy is the performance tuning work. This usually involves initial contact with a new client who is having performance …
If you frequently connect to many different SQL Server as I do, you are probably used to the Server Manager loading slowly when you log in with Remote Desktop. The Server Manager has a bad reputation for taking up lots …
I have just released version 2.4.3 the July 2016 version of Database Health Monitor. You can download it now at the Database Health Monitor website. http://DatabaseHealth.com/download Since the releases have been coming about monthly lately, I have decided to add …
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? …
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 …
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 …
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 …
I started out the day with the keynote presentation with some great info on PASS and the PASS volunteers, followed by Microsoft presenting on in memory tables, and native compilation for stored procedures, described and demonstrated as “Wicked Fast”. Next …
Quite often when working testing different performance measures from the Database Health Reports to testing Resource Governor configuration I end up in a situation where I need to emulate a high CPU load on my test SQL Server. In this …