What is this?

This knowledgebase contains questions and answers about PRTG Network Monitor and network monitoring in general.

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

How to make WMI SQL service sensors work again for cluster device?

Votes:

0

Hello, We have an SQL cluster device added to PRTG, within this device we have added several WMI sensors. In this case we have 6 SQL services that are being monitored via WMI for over a year, about a week ago, 4 of those sensors went into down state and have not been able to come back to up state after they were paused. We have tried pausing and resuming, and also re-adding the sensors, after they are resumed it takes several minutes to read into the error state even when the services are running fine in the actual cluster computer. Also when adding sensors to PRTG, the services show as running but the sensor is always in the Unknown then goes to error after several minutes.

Any ideas or suggestions about this behavior?

Thanks.

Vicky Barraza

services sql wmi

Created on Aug 13, 2014 8:50:58 PM



7 Replies

Votes:

0

Hello,

thank you very much for your support ticket. May I ask, which exact version of PRTG are you running? Which exact error do the sensors show? Can you upload a screenshot showing the "Overview" and one screenshot showing the "Settings"-Tab of such a sensor?
Also, are you monitoring the cluster nodes directly each one?

best regards.

Created on Aug 18, 2014 11:12:51 AM by Torsten Lindner [Paessler Support]



Votes:

0

Sure, we are currently running PRTG version 14.2.10.2014. Where do you want me to upload the screenshots for this error?, please advise on that. And yes, we are monitoring the nodes directly for both SQL servers in the cluster, but since one is active and other passive.

Thanks.

Created on Aug 18, 2014 4:03:06 PM



Votes:

0

Please upload the images to a image-share platform and then link them here.

Created on Aug 19, 2014 8:13:23 AM by Torsten Lindner [Paessler Support]



Votes:

0

Hi Torsten, After reading your reply, I went and un-pause one of the sensors giving me the error (to capture screenshot) and encountered something else. A few more sensors were in unknown state for a few minutes, then they went into warning with the same error as the SQL sensors we talked about before. "WMI request timed out unrecoverably. If the problem persists with this sensor consider pausing or deleting it"

The new sensors showing the warning are not even from the same devices, which means there were different servers throwing this error. Do we know if the version of PRTG that we are running has a bug regarding this matter?, would it be better and quicker to resolve this issue if we open a ticket?.

Thanks.

Created on Aug 19, 2014 2:18:52 PM



Votes:

0

Torsten, Here are the links to the requested screenshots: Overview: http://pcds.profilesinternational.com/it/001.jpg Settings: http://pcds.profilesinternational.com/it/002.jpg and http://pcds.profilesinternational.com/it/003.jpg

Thanks.

Created on Aug 19, 2014 3:49:56 PM



Votes:

0

With the WMI Requests hanging here, please try restarting the PRTG Probe Service. If that does not help, please try restarting the target machines.

Created on Aug 19, 2014 4:03:29 PM by Torsten Lindner [Paessler Support]



Votes:

0

Thanks, this has been fixed, the issue was with WMI on the target machine on SQL. After fixing this and un-pausing sensors they came back up. The others which were showing as warning cleared themselves after sometime.

Created on Aug 19, 2014 9:49:35 PM




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.