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:

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,

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

Hi Tomasz,

Please see the table below.

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