There are a lot of monitoring softwares out there such as Nagios, Zabbix, Idera, SQLMonitor, Aim Better, Data Dog, Solarwinds, etc. Yes, there are so many vendors and brands you can’t even count them using your bare hands.
They are make themselves available as on premise software, SaaS, and Cloud. Doesn’t matter it one is full featured or poor, if one uses machine learning or come with no intelligence, all of them come with a common issue:
THEY WILL MAKE YOU SUFFER AND ANNOYED WITH TONS OF EMAILS, SMS, WHATSAPP MESSAGES
Now you have needy servers, and emails/messages to be read (maybe) and deleted. That’s the point: keep your attention on really noble tasks. I can guarantee that reading email alerts is not. And that’s is my point when talking about monitoring tools. For more the 30 years working with databases of diverse vendors (Oracle, IBM, Microsoft, and other weird animals) I have searched for a monitoring tools to help keep me focused on the database not in alerts. I have found NONE.
Nagios and Zabbix are too generic like aspirin for kidneys. Aim Better is pretty interface. SQL Monitor is doing a good job. Data Dog barks a lot. Solarwinds and Idera are great but expensive.
Because of this I have decided to build from scratch a 100% SaaS monitoring and advisory tool that delivers charming charts for quick analysis, machine learning based, tickets management and knowledge base, scheduling, auditing and the most important it comes with free NOC. It means that somebody will call me (yes, call by phone and other means) when something goes wrong. No longer emails and SMS will distract me. No more night shifts.
That’s my idea of Virtual DBA.