Purpose:
One of my client is planning to create a centralized monitoring system for all their databases. Due to budget constraint they thought of going for Nagios. From MS SQL Server end, to have the basic understanding on what is Nagios and the feasibility, I have done a small POC. Below are the areas, I have worked, read and learnt on Nagios.
About Nagios:
üNagios
is
a monitoring and alerting engine.
üIt
does
ØSystem Monitoring
ØDatabase Monitoring
ØApplication Monitoring
üIt
serves
as the basic event scheduler, event processor, and alert manager for elements
that are monitored.
üIt
is designed
to run natively on Linux/Unix systems.
üProducts:
ØNagios XI
ØNagios Core
ØNagios Fusion
ØNagios Incident Manager
ØNagios Network Analyzer
Pre-requisite:
ØNagios
Enterprises highly recommends and will only support installing Nagios XI on a
newly installed, “clean” system
ØAttempting
to install Nagios XI on a pre-existing system with other applications already
installed can cause the Nagios XI installation process to
fail
ØInternet
access is required for installation and upgrades!
ØLinux
distributions:
qRHEL 5 & 6 32-bit and 64-bit
(requires RHN registration)
qCentOS 5
& 6 32-bit and 64-bit
Database Monitoring:
ØNagios
XI is the product to be installed for database monitoring.
ØNagios
supported databases:
üMy SQL
üPostgres
üDB2
üOracle
üMS SQL Server
Installation:
http://ptihosting.com/blog/it-blog/monitor-mssql-with-nagios/
(Monitor from Linux)
Plugins for SQL Server:
Pricing:
Conclusion:
Considering the pricing as compare to other monitoring tools, Nagios is cheap for licensing and support. But to do so, the person configuring requires linux/unix knowledge with Nagios core also it is not easy and time consuming, since it requires linux server with Nagios installation. Overall it definitely a choice for who wants to implement monitoring tool having cost constraint.
References:
E-Book:
Few links:
Online Demo:
No comments:
Post a Comment