Nagios Support Forum

"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

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