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 xp_delete_file the you may want to look at your backup cleanup jobs. Lets take a look at what you may actually be seeing – see image above What is shown in the image above is …

Xp_delete_file and Preemptive_Os_GetProcAddress waits Read more »

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 …

Database Health Monitor – Historic Waits Read more »

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 »

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 …

Database Health Monitor -Beta Version 10.1 Released Today Read more »

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 continuously monitors your SQL Server database and logs the details around queries that are causing waits. Here is an example, the following ugly block of TSQL updates a table with a few million rows in …

Beta 3 is Now Available. Read more »