• 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 alters to correct existing installations.

    Please let me know if you encounter any issues. We tested on 2005, 2008R2 and 2012 SP1 with databases up to 1TB.

    Changelog:

    - Renamed created database from dba to dbWarden

    - Changed defaults of DatabaseSettings table to OFF for everything. REPLACE CHANGEME in Update to DatabaseSettings to enable

    databases you wish to track (this also fixes issues when trying to track a database that is OFFLINE

    - Updated Instructions at the top

    - usp_MemoryUsageStats - Fixed Buffer Hit Cache and Buffer Page Life showing 0 for SQL Server 2012

    - dbo.FileStatsHistory table, usp_FileStats and rpt_HealthReport procs- Changed NVARCHAR(30) to BIGINT for Read/Write columns, FileMBSize, FileMBUsed, FileMBEmpty in #FILESTATS

    - rpt_HealthReport - hopefully fixed the "File Stats - Last 24 hours" section to show accurate data

    - usp_CheckFiles - Added database names "[model]" and "[tempdb]"