Microsoft SQL Server (MSSQL) Monitoring With Nagios


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


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


These Nagios solutions provide MSSQL monitoring capabilities and benefits:


See Also

Recommended Software: Nagios XI


Nagios XI is the most powerful and trusted infrastructure monitoring tool on the market. Millions of users and thousands of companies - ranging from Fortune 500s to small business owners - trust Nagios XI to get the job done.