Blog Archives

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

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

Database Health Monitor Version 2.4.1 Released

Just one day after releasing Database Health Monitor version 2.4, today I released version 2.4.1. Version 2.4.1 includes a bug fix and 2 new feature that were added after the release of version 2.4. Feature: Support for SQL Server 2016. Since

Posted in Database Health Tagged with: , ,

Database Health Monitor Version 2.4 Released

If you haven’t tried Database Health Monitor Version 2.4 might be a good time to try it out. Five and a half years of my development time has gone into Database Health monitor, and hopefully the features will show it. Here

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

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

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

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: , , , , , ,

SQL Server Performance Tuning

Need help with SQL Server Performance Tuning, contact Steve at Stedman Solutions, LLC for help, or take a look at the performance tuning page at the SteveStedman.com blog. We can help with tuning a single query or with figuring out why your SQL Server is running slow. Free 30 minute consultation.

Newsletter Signup

Stay informed of Database Corruption Challenge events, and other things happening at SteveStedman.com with my newsletter.
Newsletter signup form.

Stedman Solutions

StedmanSolutionsRemoteSkilledDBA

Archives