If you are noticing a number of waits showing up on your SQL Server of type PREEMPTIVE_OS_GETPROCADDRESS and it is linked to the system procedure… Read More »Xp_delete_file and Preemptive_Os_GetProcAddress 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 purpose of this blog series is to present some of the features of the product.
If you haven’t tried Database Health Monitor, you can download it at http://DatabaseHealth.com/download. It is completely free.
The Historic Waits section of Database Health monitor is in my opinion the single most valuable part of the entire product. Other vendors sell products similar the Historic Waits feature for $1500 to $2000 per SQL Server instance, making it cost prohibitive for many.
The way that Historic Waits works is that it installs a small monitoring database on a SQL Server, that can be the same SQL Server you are monitoring, or it can be a separate SQL Server just to keep track of performance.
Over time data is collected in this monitoring database that allows you to then step back in time to see what was happening with the SQL Server at a specific point in time. For instance, if you have Historic Monitoring enabled, if someone comes to you and says “The SQL Server was slow and having problems at 2:00am yesterday”, you have the ability to track down what was happening at that point in time.
The main Historic overview page shows Waits, Plan Cache Hit Ratio, Page Life Expectancy and CPU Load over time.
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… Read More »Database Health Monitor Beta 10.2 Released Today
Today is the release of Database Health Monitor Beta 10.1. If you haven’t see the Database Health Monitor before, its a free application that I have been building over last 4 years.
It has been a while since the last release, so I thought I would just walk through and show a few of the features.
One thing that changed right off was in the previous version, these was a advertisement for my IndieGoGo campaign where I attempted to crowd fund the next phase of development on Database Health Reports. The IndieGoGo campaign has been removed.
The real time reports are a category of reports that query the database directly to find out something that is currently happening right now. See the Historic Reports below for the ability to find out what was happening at some point in the past.
One of the new reports added is the Suspect Paged report. If you have been participating the Database Corruption Challenge you will certainly understand the value of this report.
Read More »Database Health Monitor -Beta Version 10.1 Released Today
One big new feature in Beta 3 of the Database Health Reports, the historic monitoring. The way that the historic monitoring works is that it… Read More »Beta 3 is Now Available.