check_mssql_health is a plugin for Nagios that allows you to monitor an MS SQL Server. Among the list of metrics are time to login, buffer cache hit rate, page life expectancy, full table scan rate, free space in databases, batch requests/second, and many more. Installation of the DBD::Sybase Perl module is required.
|Tags||Nagios Plugin SQL Server Windows|
Release Notes: Mode SQL can now have non-numerical output that is compared to a string/regexp. There is a new –dbthresholds parameter, and a new mode report to output only the bad news.
Release Notes: A bug in database-free where too much free space was calculated when more than one data file of a database was on the same filesystem was fixed. A new extra-opts parameter were added.
Release Notes: The --dbthresholds parameter was added. Thresholds can now also be deposited in the table check_mssql_health_thresholds. The --currentdb parameter was added so that the plugin can connect to a non-default database. The new command-line parameter, --with-mymodules-dyn-dir, overrides the configure-option of the same name. The connection method "sqlcmd" was added as an alternative to the dbi-method. The new mode "database-backup-age" was added.
Release Notes: Database names may now contain special characters. A new parameter --server was added. This release is compatible with SQL Server 2000.
Release Notes: Several bugfixes were made. Support for SQLRelay was added. For databases with unlimited growth, the mode database-free now takes the available disk space into account.