Microsoft SQL Server (MSSQL) Monitoring With Nagios

Capabilities

Nagios XI provides complete monitoring of MSSQL – including availability, database and table sizes, and a number of other key metrics!

The easy to use built-in MSSQL Database Wizard features metrics like:

Connection time
Database size
Log File Usage
Active Transactions
Transactions Per Second
Log Cache Hit Ratio
Log Waits
Log Growths
Log Shrinks
Log Truncations
Log Flushes Per Second

Nagios XI also includes a MSSQL Server Wizard that allows administrators to gain insight on:

Connection Time
Buffer Hit Ratio
Page Looks
Free Pages
Target Pages
Database Pages
Stolen Pages
Lazy Writes
Read Aheads
Page Reads
Check Pages
Lock Requests
Lock Timeouts
Deadlocks
Lock Waits
Page Splits
Lock Wait Time
Average Wait Time

Benefits

Implementing effective MSSQL monitoring with Nagios offers the following benefits:

Increased application availability
Increased database performance
Fast detection of database outages, failures, and table corruption
Predictive analysis of storage requirements and index performance

Offloading MySQL to Remote Server

This document offers a step-by-step guide for offloading the MySQL services from the central Nagios XI server to an external, remote server.

Offloading MySQL to Remote Server

Solutions

These Nagios solutions provide MSSQL monitoring capabilities and benefits:

Resources

See Also