New Question
 
 
PRTG Network Monitor

Intuitive to Use.
Easy to manage.

200.000 administrators have chosen PRTG to monitor their network. Find out how you can reduce cost, increase QoS and ease planning, as well.

Free PRTG
Download >>

 

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

 

Top Tags


View all Tags


Why does my WMI Microsoft SQL Server 2005 Sensor not work anymore?

Votes:

0

Your Vote:

Up

Down

After a Windows update, the WMI Microsoft SQL Server 2005 sensor does not work anymore. What is the reason for this?

prtg sensor sql sql-server sql-server-2005 windows windows-update wmi

Created on Dec 12, 2012 10:41:01 AM by  Gerald Schoch [Paessler Support]

Last change on May 6, 2019 11:13:05 AM by  Maike Behnsen [Paessler Support]



4 Replies

Accepted Answer

Votes:

0

Your Vote:

Up

Down

This article applies to PRTG Network Monitor 19 or later

Deprecated Sensor Type WMI Microsoft SQL Server 2005

With the latest updates of SQL Server 2005, which were delivered by Microsoft in August 2012, it cannot be monitored with PRTG anymore. Thus, monitoring SQL Server 2005 is discontinued. The following updates cause this issue:

We have made reasonable effort to fix this from our side, but we were unable to do so. We do not have instructions to circumvent this issue at this time. Please ask the vendor to fix this.

Created on Dec 12, 2012 10:47:30 AM by  Gerald Schoch [Paessler Support]

Last change on Jul 25, 2019 8:56:58 AM by  Maike Behnsen [Paessler Support]



Votes:

2

Your Vote:

Up

Down

You can still monitor your SQL Server 2005 with Custom Sensor PTF.SQLspXML

This sensor parses -multi channel- data from your SQL Server to PRTG.

First create a new Stored Procedure on your SQL Server using the code below:

CREATE PROCEDURE spSQLCounters
AS
BEGIN
SELECT
	 counter_name AS Channel
	,cntr_value   AS Value
	,1            AS IsInt
	,'#'          AS Unit
FROM sys.dm_os_performance_counters
WHERE counter_name IN (
	 'Active Temp Tables'
	,'Connection Reset/sec'
	,'Event Notifications Delayed Drop'
	,'HTTP Authenticated Requests'
	,'Logical Connections'
	,'Logins/sec'
	,'Logouts/sec'
	,'Mars Deadlocks'
	,'Non-atomic yield rate'
	,'Processes blocked'
	)
ORDER BY counter_name
END 

This will return a result set like:

ChannelValueIsIntUnit
Active Temp Tables1871#
Connection Reset/sec2380179151#
Event Notifications Delayed Drop01#
HTTP Authenticated Requests01#
Logical Connections1031#
Logins/sec14566071#
Logouts/sec14565041#
Mars Deadlocks01#
Non-atomic yield rate28300171#
Processes blocked01#

PTF.SQLspXML will consume this result set and literally parse it into PRTG. More examples and how to setup the sensor is described in the download.

Note: you can use

SELECT * FROM sys.dm_os_performance_counters

To get a complete listing of all counters that you can monitor.

Regards,

Created on Dec 12, 2012 7:14:59 PM by  PRTG Tools Family [prtgtoolsfamily.com] (12,925) 3 4



Votes:

0

Your Vote:

Up

Down

Is there a way to connect with PTF.SQLspXML to other than default SQL instance running on a different TCP port?

Created on Jun 7, 2016 9:18:29 PM by  Tomasz (161) 1 1



Votes:

0

Your Vote:

Up

Down

Hi Tomasz,

Please see the table below.

Default-s=myServerName
Instance name-s=myServerName\myInstanceName
Portnumber-s=myServerName,1234

It's not necessary to specify an instance name when specifying the port

Created on Jun 8, 2016 1:31:19 PM by  PRTG Tools Family [prtgtoolsfamily.com] (12,925) 3 4



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.