dbWarden is a comprehensive database monitoring and alerting solution for SQL Server 2005. 2008 and now 2012. It features email and text notifications with customizable metrics for alerts such as Blocking, Long Running Queries and SQL Jobs, CPU %, Log file and TempDB growth. Another main feature is a detailed HTML based daily health report which provides a thorough overview of your database server.
dbWarden is written completely in SQL and requires sysadmin level permissions to run xp_instance_regread and xp_fixeddrives. Utilizes SQL Agent, DBMail and Operators.
Features
- Completely Free
- SQL-based for easy and quick installation and setup
- Compatible with all editions of SQL Server 2005, 2008 and 2012 except for Express (requires SQL Agent and DBMail)
- Receive a comprehensive and configurable daily "Health Report" that provides a thorough overview of your SQL Server
- Sends alerts via email or text using DBMail
- Includes sp_Sessions to monitor session and query performance
- Monitors your database servers for:
- - Long running queries
- - Long running Jobs
- - Blocking
- - Log file and TempDB growth
- - CPU utilization
- - Schema Change Tracking
- - Reporting on deadlocks
Project Samples
License
Creative Commons Attribution LicenseOther Useful Business Software
Comprehensive data protection. Simple recovery. Built in trust and transparency. See for yourself why Spanning is the leading cloud-to-cloud backup solution.
Rate This Project
Login To Rate This Project
User Reviews
-
Well done, thank you. With little customization it will easily substitute expansive monitoring solutions.
-
Would give this five stars, but the usp_filestats procedure in version 2.5.2 is throwing a "Msg 8115, Level 16, State 2, Line 40 Arithmetic overflow error converting expression to data type int." which is causing the health report job to fail. I am running this on SQL Server 2012, SP3.
-
SQL Server 2012 SP3, error in Replication monitor section, need to add another column name of publisher NVARCHAR(128) to the end of the table definition.
-
I think I found a small bug in the procedure usp_FileStats. When inserting into #FILESTATS you are putting brackets around @dbname. For me this causes the flags in alertsettings table not to work because of the checks in FileStatsHistory table.
-
A terrific tool that I have deployed on many servers, definitely recommended. thank you very much for your hard work and making it available to everyone. There is a request I would like to make if you don't mind: if you have the time what would be very useful would be a way to collate all the data generated into a central location so aggregate reports could be created for all the servers monitored for MI reporting. I have started working on that myself using your existing code but I am sure you would do a better job. Thanks again.