Is there a way, sensor to monitor SQL 2014 Always On Availability groups? I want to see which DBs are being protected and which one is primary, secondary, what is the health of the cluster
Article Comments
Are there any plans to create a dedicated sensor for this? Im also looking for a way to check which DBs are being protected and which one is primary, secondary, what is the health of the cluster. Is there some Feature Request form?
Mar, 2016 - Permalink
Hi there,
there are no plans to create a native sensor for this at the moment. Let's see if more people request this sensor type so that we can consider to work on a new sensor type. Please have a look here to see how we handle your feature requests.
There are some useful guides available in the internet, this one might help you to create your own query.
Best regards, Felix
Mar, 2016 - Permalink
Hi, a sensor for monitoring AlwaysOn would be much appreciated. Veritas finally got around to support AlwaysOn in Netbackup so we are deploying it now. A sensor to monitor replication status for example would be very useful.
May, 2016 - Permalink
It would be really good if PRTG could aim to have similar functionality as https://msdn.microsoft.com/en-us/library/ff877954.aspx for monitoring MSSQL AlwaysOn.
Jun, 2016 - Permalink
Hi Olav,
The author of the article mentions, that the metrics are available via Performance Counters. Therefore, you can follow this article to create a PerfCounter Custom Sensor for the SQLServer:Availability Replica performance object.
Best regards, Felix
Jun, 2016 - Permalink
Did you see Felix' reply? This one:
The author of the article mentions, that the metrics are available via Performance Counters. Therefore, you can follow this article to create a PerfCounter Custom Sensor for the SQLServer:Availability Replica performance object.
Did you already try that? Perhaps it already works fine for you :)
PRTG Scheduler |
PRTGapi |
Feature Requests |
WMI Issues |
SNMP Issues
Kind regards,
Stephan Linke, Tech Support Team
Jan, 2019 - Permalink
It's very unlikely that this will be implemented I'm afraid. Too little demand among our customers :(
Jan, 2020 - Permalink
Hello Stephan. I really think you should reconsider making this sensor part of PRTG. Everyone who runs an SQL cluster would benefit from this.
Jan, 2020 - Permalink
@Michael
Would you mind posting this as an official feature request, since you likely know what metrics are important in that regard? Here's our Guide for Feature Requests. Thanks, much appreciated!
Jan, 2020 - Permalink
Hello,
I'm afraid that there is no native sensor to monitor MS SQL Always ON solution. There is no plan yet to include such sensor in PRTG, therefore I invite you to check if a feature request is already opened and vote for it.
If there is no opened feature request yet, then please follow the procedure described here to open one for it.
Regards.
Jan, 2021 - Permalink
we use the following and if it returns no rows we know there is a HA issue
select Master as Database
SELECT [synchronization_health]
FROM [master].[sys].[dm_hadr_availability_group_states] where [synchronization_health] = 2
Dec, 2021 - Permalink
We have no dedicated sensor that is able to provide that info "out of the box". However there could be options like using a PerfCounter Custom Sensor that polls specific Performance Counters or using an MS SQL v2 Sensor to perform queries that deliver the desired information.
Maybe this article can be useful.
Kind regards.
Feb, 2016 - Permalink