Virtual Log Files (VLFs) are part of the SQL Server log file. When space is allocated in the log due to growth, that new chunk of log is broken up into Virtual Log Files. High VLF counts can slow down the following actions: – Transaction Log Backup – Crash Recovery, the process your database goes through on startup. – Writing …
Steve Stedman and the Stedman Solutions Team celebrate the 10 year anniversary of Database Health Monitor. Kiana talks to Steve about this tool he built, how it’s evolved, why its useful and its plans for it in the future. Go to http://www.Databasehealth.com to download this free tool today! STEVE: This is the 10-year anniversary of database health monitor and it …
Have you tried out Database Health Monitor and the Quick Scan report? The Quick Scan report does a quick check (sometimes not so quick depending on the system). It checks for server best practice recommendations, and security and performance recommendations as suggested by Database Health Monitor. You can get to the Quick Scan report from the “Instance Reports” section of …
Thanks to the successful funding campaign on Indiegogo I was able to fund the November 2019 release of Database Health Monitor. Here are the release notes. Version 2.9.4 Release Notes Version 2.9.4 is the November release of Database Health Monitor. New Reports New Features Bug Fixes Here is a look at the start of the new security report: And here …
November 2019 Release of Database Health Monitor Read more »
Can you help fund the next release of Database Health Monitor? I have started an Indiegogo funding campaign for the November release of Database Health monitor. Not asking for a lot here, just $500 to help fund the next release of Database Health Monitor. What We Need & What You Get I am looking to raise $500 (us dollars) to …
Funding the November release of Database Health Monitor Read more »
Earlier today I had the opportunity to release the September update of Database Health Monitor. This is version 2.91. One of the updates is a new feature called aliasing, where you can add a tag to the name of the server in the tree view on the left hand side as shown in the picture below. The first database in …
Year over year we have had an increase in the number of people regularly using Database Health Monitor as shown in the chart below. I would like to see this grow at a faster rate, but it does show that the people who use Database Health Monitor continue to use it. Also I have received several feature requests lately from …
Today I released the August 2019 release of Database Health Monitor. This is version 2.9. My favorite new report is the Blocking By Hour of Day report which uses the existing data that is collected by the historic monitoring feature. Below is a list of some of the things that have been fixed or added in this version and the …
Yesterday I released the first update to Database Health Monitor in a couple of months. There were some new features and some fixed saved up that were released yesterday. I did however run into 2 small bugs that were quickly dealt with in version 2.8.0 and 2.8.1. With some quick bug reporting for a couple of super users, and some …
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 how thing are changing over time on your system. You can even answer questions like “The server was running slow …
Database Health Monitor – Historic Wait Monitoring Read more »