What is this?

This knowledgebase contains questions and answers about PRTG Network Monitor and network monitoring in general. You are invited to get involved by asking and answering questions!

Learn more

PRTG Network Monitor

Intuitive to Use. Easy to manage.
More than 500,000 users rely on Paessler PRTG every day. Find out how you can reduce cost, increase QoS and ease planning, as well.

Free Download

Top Tags


View all Tags

SQL Always On HA monitoring

Votes:

2

Your Vote:

Up

Down

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

prtg sql wmi

Created on Feb 8, 2016 7:31:10 PM by  gskowronek (2) 1



22 Replies

Accepted Answer

Votes:

0

Your Vote:

Up

Down

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.

Created on Feb 10, 2016 12:48:25 PM by  Erhard Mikulik [Paessler Support]

Last change on Feb 10, 2016 12:48:37 PM by  Erhard Mikulik [Paessler Support]



Votes:

0

Your Vote:

Up

Down

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?

Created on Mar 23, 2016 4:12:02 PM by  andewegs (0)



Votes:

0

Your Vote:

Up

Down

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

Created on Mar 24, 2016 5:39:36 AM by  Felix Saure [Paessler Support]



Votes:

0

Your Vote:

Up

Down

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.

Created on May 2, 2016 12:20:03 PM by  Olav Langeland (0)



Votes:

0

Your Vote:

Up

Down

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.

Created on Jun 3, 2016 8:23:30 AM by  Olav Langeland (0)



Votes:

0

Your Vote:

Up

Down

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

Created on Jun 3, 2016 8:55:30 AM by  Felix Saure [Paessler Support]



Votes:

0

Your Vote:

Up

Down

one more request

Created on Aug 23, 2018 6:09:39 AM by  [email protected] (0)



Votes:

0

Your Vote:

Up

Down

One more request from us :)

Created on Jan 7, 2019 9:25:37 AM by  Michael (30) 1



Votes:

0

Your Vote:

Up

Down

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

Created on Jan 8, 2019 11:30:56 AM by  Stephan Linke [Paessler Support]



Votes:

0

Your Vote:

Up

Down

Need this sensor - very important on SQL AG Monitoring

Created on Dec 16, 2019 9:32:42 AM by  sukubala (0) 1



Votes:

0

Your Vote:

Up

Down

Plus 1 for SQL AG monitoring and Distributed AG monitoring

Created on Jan 6, 2020 9:42:00 AM by  fam_987 (0)



Votes:

0

Your Vote:

Up

Down

It's very unlikely that this will be implemented I'm afraid. Too little demand among our customers :(

Created on Jan 7, 2020 1:14:08 PM by  Stephan Linke [Paessler Support]



Votes:

1

Your Vote:

Up

Down

Hello Stephan. I really think you should reconsider making this sensor part of PRTG. Everyone who runs an SQL cluster would benefit from this.

Created on Jan 8, 2020 6:39:53 AM by  Michael (30) 1



Votes:

0

Your Vote:

Up

Down

@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!

Created on Jan 9, 2020 10:56:56 AM by  Stephan Linke [Paessler Support]



Votes:

0

Your Vote:

Up

Down

SQL AG monitoring and Distributed AG monitoring yet??

Created on Oct 26, 2020 8:07:13 AM by  nakatsue (0)



Votes:

0

Your Vote:

Up

Down

Did you guys check this out already? :)

Created on Oct 26, 2020 3:30:35 PM by  Stephan Linke [Paessler Support]



Votes:

3

Your Vote:

Up

Down

I have created an MS SQL AG sensor if anyone is still interested

Created on Jan 8, 2021 3:41:44 PM by  ajturs (30)



Votes:

0

Your Vote:

Up

Down

Is it possible to monitor MS SQL Always ON? When does such a method come?

Created on Jan 12, 2021 8:14:20 AM by  muhammet854 (0)



Votes:

0

Your Vote:

Up

Down

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.

Created on Jan 12, 2021 10:47:50 AM by  Florian Lesage [Paessler Support]



Votes:

0

Your Vote:

Up

Down

@ajturs How did you get it?

Created on Apr 12, 2021 8:39:58 AM by  mirazabal (0)



Votes:

0

Your Vote:

Up

Down

@ajturs

are you able to share your AG sensor?

Created on Dec 10, 2021 10:04:15 AM by  Mike Freestone (0)



Votes:

0

Your Vote:

Up

Down

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

Created on Dec 10, 2021 12:52:21 PM by  Mike Freestone (0)



Please log in or register to enter your reply.


Disclaimer: The information in the Paessler Knowledge Base comes without warranty of any kind. Use at your own risk. Before applying any instructions please exercise proper system administrator housekeeping. You must make sure that a proper backup of all your data is available.