I'm searching for a budget-friendly application to monitor several SQL instances. Currently, we use LibreNMS for basic server and network monitoring, but it doesn't provide in-depth insights into SQL performance, such as query efficiency. I've previously used Red Gate in another position, but I'd like to know if there are any other options I should consider.
4 Answers
Have you looked into using the LibreNMS plugin? It might do the trick for you. You can check it out here: [LibreNMS MySQL Plugin Documentation](https://docs.librenms.org/Extensions/Applications/MySQL/). However, keep in mind that it's mainly for MySQL and MariaDB.
We've been using SQL Sentry from SolarWinds, which works pretty well, but it's not exactly cheap, especially if you're only monitoring a few instances. However, when we migrated to MSSQL, it helped us out a lot in tracking down performance bottlenecks.
You might consider using Prometheus with Grafana. The setup might take some effort, but it can save you money. There's also Netdata, although they push their paid service pretty hard. Check out Brent Ozar's First Responder Toolkit too; it's invaluable!
If you're open to setting up a virtual machine, Zabbix could be a great choice since it's free! There’s also a cloud offering, though I haven't explored that myself.
Related Questions
Can't Load PhpMyadmin On After Server Update
Redirect www to non-www in Apache Conf
How To Check If Your SSL Cert Is SHA 1
Windows TrackPad Gestures