After a Windows update, the WMI Microsoft SQL Server 2005 sensor does not work anymore. What is the reason for this?
Why does my WMI Microsoft SQL Server 2005 sensor not work anymore?
Votes:
0
4 Replies
Votes:
0
This article applies as of PRTG 22
Deprecated sensor type WMI Microsoft SQL Server 2005
With the latest updates of SQL Server 2005, which were delivered by Microsoft in August 2012, you cannot monitor it with PRTG anymore. Therefore, monitoring SQL Server 2005 is discontinued. The following updates cause this issue:
- Security Update for SQL Server 2005 Service Pack 4 (KB2716429)
- Security Update for SQL Server 2005 Service Pack 4 (KB2716427)
We have made a reasonable effort to fix this from our side, but were unable to do so. Please ask the vendor for support in this matter.
Created on Dec 12, 2012 10:47:30 AM by
Gerald Schoch [Paessler Support]
Last change on Jun 1, 2022 11:20:13 AM by
Brandy Greger [Paessler Support]
Votes:
2
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:
Channel | Value | IsInt | Unit |
---|---|---|---|
Active Temp Tables | 187 | 1 | # |
Connection Reset/sec | 238017915 | 1 | # |
Event Notifications Delayed Drop | 0 | 1 | # |
HTTP Authenticated Requests | 0 | 1 | # |
Logical Connections | 103 | 1 | # |
Logins/sec | 1456607 | 1 | # |
Logouts/sec | 1456504 | 1 | # |
Mars Deadlocks | 0 | 1 | # |
Non-atomic yield rate | 2830017 | 1 | # |
Processes blocked | 0 | 1 | # |
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,
Votes:
0
Is there a way to connect with PTF.SQLspXML to other than default SQL instance running on a different TCP port?
Votes:
0
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
Add comment