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: