dbWarden 2.3.9 has been released! A lot of fixes in the health report and reporting of tempDB and Log file growth. Thanks to Volker.Bachmann and Matt Monroe for their work!

Note...

Thanks for the fixes, I'll get them added today. As for the paired down report, what did you have in mind for what's displayed? I like the idea. I've been...

Thanks Tim, I added in your changes and just posted a 2.3.8 update on the Sourceforge page.

Chanagelog

- QueryHistory table - added Formatted_SQL_Text column. (There are now two columns storing...

The arithmetic overflow issue is fixed, an updated version (2.3.7) is on the SourceForge page.

T_Peters (4/22/2013)

---

This is great work! Thank you very much for sharing your work.

I ran into the "Arithmetic overflow error converting expression to data type int" on the dba_CheckFiles job and...

We updated the script to 2.3.6, it's available for download on the dbWarden Sourceforge page.

Changelog:

Simplified usp_LongRunningQueries to use DMV's to gather session information.

Altered QueryHistory table to accomodate changes in usp_LongRuningQueries

Altered...

gazzer (4/21/2013)

---

Hi, thanks a great deal, that helped me out and it is now working.

I had originally set-up to use in another Database, but then went with the default, and...

Our apologies. It's been removed from the script as of now. I will get a new version released today that doesn't utilize your procedure to gather query data.

gkiss,

Thanks, I will take a closer look at that section.

I only ran replication on one of my test systems when I wrote that section, the rest of the test...

Data purging is something we've talked about but have deferred on because we wanted to eventually incorporate some sort of analytics. It's a work in progress for sure 🙂

dbWarden 2.3.5 is now available on sourceforge. Please note, we changed the default database name from "dba" to "dbWarden"

There are also a few table changes, but the script contains safe...

gkiss 73362 (4/16/2013)

---

I'm still struggling with the Health Report. I see now that every time the job runs, I get an email. That was being sent out all along ...

ShawnTherrien (4/16/2013)

---

Looks like everything but the longest running jobs are working. I got my first daily health check email.

My only feedback for what I'm seeing so far is that it...

If the CellList field is...

Thanks SAinCA! There is an updated script on the SourceForge page that contains this fix.

There are a few other fixes in this update as well. All the gen_Get* stored procs...