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

Recommended Software: Nagios XI

about-screenshot


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.

盛源彩票注册 极速3D彩票 必赢国际线上娱乐网址 贵州快3走势 速发彩票开户 安徽快3走势 爱投彩票开户 河北快3开奖 pk10怎么玩 K8彩票开户