SQL Monitor Recommendations
Posted by DuckDuckBadger@reddit | sysadmin | View on Reddit | 10 comments
Looking for an affordable app to monitor a handful of SQL instances. We use LibreNMS to monitor basic server, network, etc performance but this doesn’t give detailed information into SQL like query performance and more. I’ve used Red Gate in a previous role, but curious if there’s anything else I should be considering.
crreativee@reddit
Given your previous experience with Red Gate, you'll find Applications Manager offers a similar level of dedicated database insight but it comes with a more flexible pricing model that might align with your requirements.
whetu@reddit
It'd be a bit of work, but Prometheus exporter + Grafana will only cost you the setup time.
Netdata can, presumably, shorten the setup time.
Signoz might have something for you.
Brent Ozar's First Responder Toolkit is a must-have regardless.
ken_griffin_aka_mayo@reddit
You open to spin up a VM? In that case Zabbix is free. There's a cloud offering too that I've never explored.
DuckDuckBadger@reddit (OP)
Open to it, I’ve been considering replacing Libre with Zabbix for a while but LibreNMS does everything I need it to, except for the SQL component.
vppencilsharpening@reddit
I'm a fan of Zabbix, but it is not necessarily better than LibreNMS.
Zabbix does have a MS SQL Server monitoring template that provides SQL Server specific metrics, but I'm guessing you could also pull that into LibreNMS. A lot of times the hard part is knowing what metrics exist and deciding which to record.
You can find the Zabbix template here with some info on what data it is collecting: https://git.zabbix.com/projects/ZBX/repos/zabbix/browse/templates/db/mssql_agent2?at=release/7.2
To address your original question, we used Idera for a while, but ended up dropping it due to the cost. Not sure how it ranks against Red Gate.
TheNewFlatiron@reddit
We use https://www.solarwinds.com/sql-sentry, which is decent, but I don't think this really qualifies as affordable for a handful of instances.
ephemere_mi@reddit
I don't recall what the pricing was like, but we used SQL Sentry and the Plan Explorer years ago prior to the Solarwinds acquisition. It was worth every penny.
We had just migrated our on-prem ERP from Oracle to MSSQL, and lost our years of performance tweaks in the process. SQL Sentry and its related tools helped us to pinpoint which SQL queries were impacting performance, and where we needed to add indexes. We got our performance problems sorted out in short order.
The only reason we stopped using the product is that we migrated to a cloud-hosted ERP, which took most of the load off our MSSQL server. It became overkill at that point.
Bennetjs@reddit
Did you check if the plugin may be sufficient? https://docs.librenms.org/Extensions/Applications/MySQL/
DuckDuckBadger@reddit (OP)
I should clarify that this is for Microsoft SQL, AFAIK that integration is only for MySQL and MariaDB.
Bennetjs@reddit
Yes, you are correct :)