MS SQL monitoring

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
lafargeuser
Posts: 341
Joined: Thu Sep 27, 2012 12:23 am

MS SQL monitoring

Post by lafargeuser »

"o Connection Time
o Buffer Hit Ratio
o Page Looks
o Free Pages
o Target Pages
o Database Pages
o Stolen Pages
o Lazy Writes
o Lazy Writes
o Page Reads
o Check Pages
o Page Writes
o Lock Requests
o Lock Timeouts
o Deadlocks
o Lock Waits
o Page Splits
o Lock Wait Time
o Average Wait Time
o Connection Time
o Database Size
o Log File Usage
o Open Connections
o Transactions Per Second
o Log Cache Hitrate
o Monitor the log cache hit rate.
o Log Waits
o Log Growths
o Log Shrinks
o Log Truncations
o Log Flush Wait Times
o MS SQL Query Builder
"


How do I Achieve above requirement using nagios
User avatar
hsmith
Agent Smith
Posts: 3539
Joined: Thu Jul 30, 2015 11:09 am
Location: 127.0.0.1
Contact:

Re: MS SQL monitoring

Post by hsmith »

Here are some MSSQL plugins on Nagios Exchange. You should be able to find one or more plugins that meet your needs there.
Former Nagios Employee.
me.
Locked