We are looking at acquiring some software to monitor our DB, with alerts when certain thresholds are hit. I'm aware of ProTop (although I'm unsure as to the automatic alerting side), and I'm also aware of OEM. Unfortunately OEM has been priced out of what we can justify so that's not an option.
What tools do people use for this sort of thing?
ProMonitor.. which may or may not be cheaper than OEM now that BravePoint is part of PSC.
Other options are to roll your own using VSTs. Integrating with tools like Nagios is pretty trivial and a lot of the scheduling framework is already built in. Or since you are on Windows.... Windows Scheduled Tasks if you are feeling frisky.
ProTop definitely has the ability to alert on pretty much everything.
I can tell you from experience that rolling your own is going to be more costly than using a service like ProTop.
Paul
Thanks for that.
ProMonitor.. which may or may not be cheaper than OEM now that BravePoint is part of PSC.
Other options are to roll your own using VSTs. Integrating with tools like Nagios is pretty trivial and a lot of the scheduling framework is already built in. Or since you are on Windows.... Windows Scheduled Tasks if you are feeling frisky.
Flag this post as spam/abuse.
We use Nagios but only with very limitted db metrics, database up / down, sizes on disk, ... and some custom checks using ABL code.
There is a http://www.prodashboard.com/ from Allegro but at the time that we setup Nagios I had trouble configuring it so I wrote my own scripts
So is Nagios a Linux tool?
The core of Nagios is available for Linux/Unix. Agents are available for Windows that allow you to post information back to the core dashboards. There is also a NagWin distribution for Windows but I have never used it.
How hard it is to roll your own really depends on how many different alerts you want. If you just want to monitor space and DB status it is pretty easy. If you are trying to replicate the full ProTop/Promonitor/OEM environment it is obviously going to be much harder.
Yeah we need to decide what we want to monitor. Obviously the actual server performance is something that there are tools for. It's just the Progress side we will want to keep tabs on.
As always the request has come out of the blue because of trying to win some business.
Nice to know about NagiosXI
NagiosXI : Free License for Small Environments
Have a small environment you need monitored? Nagios XI will monitor up to seven (7) hosts/nodes with unlimited services free of charge! Just select the free license in the XI administration interface. Perfect for SOHO and personal use. Support services are not included when using a free license.
We're using Icinga in combination with Zabbix. We're monitoring ~300 servers with ~2000 databases.