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


Microsoft SQL v2 BETA in Difference mode

Votes:

0

Your Vote:

Up

Down

I am using Microsoft SQL v2 BETA with "Process data table" and "Difference" options switched on. I have two consecutive readouts from SQL like

20.01.16 19:49:28Id 3return 1537 [Int64]
20.01.16 19:50:28Id 3return 1528 [Int64]

I expect sensor to show "-9" value but it shows "4294967287". It seems to be a problem with presenting negative values.

What can I do to have this sensor work as I expect?

delta negative sensor sqlsensor

Created on Jan 20, 2016 6:57:38 PM by  Tomasz (121) 1 1

Last change on Jan 21, 2016 6:46:18 AM by  Luciano Lingnau [Paessler Support]



Best Answer

Accepted Answer

Votes:

0

Your Vote:

Up

Down

Hello Tomasz,
thank you for your reply.

I've received confirmation from our development that all counters within PRTG must be ever-increasing, they're built on a similar logic than we handle Delta Counters in our SNMP Delta-based Sensors which are ever-increasing. Supporting negative delta values would affect the current overflow handling and is not something we intend to change.


7.1.6. Counter32

The Counter32 type represents a non-negative integer which monotonically increases until it reaches a maximum value of 2^32-1 (4294967295 decimal), when it wraps around and starts increasing again from zero.

7.1.10. Counter64

The Counter64 type represents a non-negative integer which monotonically increases until it reaches a maximum value of 2^64-1 (18446744073709551615 decimal), when it wraps around and starts increasing again from zero.

Best Regards,

Created on Jan 26, 2016 10:17:11 AM by  Luciano Lingnau [Paessler Support]

Last change on Feb 24, 2016 9:43:16 AM by  Luciano Lingnau [Paessler Support]



3 Replies

Votes:

0

Your Vote:

Up

Down

Hello Tomasz,
we appreciate your inquiry.

Delta sensors will never display negative values, that's not possible.

Counters(The information queried by delta sensors) are designed to be ever increasing, you got the result of 4294967287 because PRTG believes that the counter increased to a point were it did overflow (back to 0) and then increased up until 1528 again.

For Delta Counters/Sensors, the value must continuously increase and never decrease.

Best Regards,

Created on Jan 21, 2016 1:36:21 PM by  Luciano Lingnau [Paessler Support]



Votes:

0

Your Vote:

Up

Down

Quote from manual:

Difference : The sensor calculates and shows the difference between the last and the current value returned from the data table.

You need to assume that difference could be negativ... please be serious, this not amount of data traffic which obviously only increase but SQL query is for ANY kind of data which can eventualy be on the dark side of zero.

Created on Jan 21, 2016 3:52:16 PM by  Tomasz (121) 1 1

Last change on Jan 22, 2016 6:51:49 AM by  Luciano Lingnau [Paessler Support]



Accepted Answer

Votes:

0

Your Vote:

Up

Down

Hello Tomasz,
thank you for your reply.

I've received confirmation from our development that all counters within PRTG must be ever-increasing, they're built on a similar logic than we handle Delta Counters in our SNMP Delta-based Sensors which are ever-increasing. Supporting negative delta values would affect the current overflow handling and is not something we intend to change.


7.1.6. Counter32

The Counter32 type represents a non-negative integer which monotonically increases until it reaches a maximum value of 2^32-1 (4294967295 decimal), when it wraps around and starts increasing again from zero.

7.1.10. Counter64

The Counter64 type represents a non-negative integer which monotonically increases until it reaches a maximum value of 2^64-1 (18446744073709551615 decimal), when it wraps around and starts increasing again from zero.

Best Regards,

Created on Jan 26, 2016 10:17:11 AM by  Luciano Lingnau [Paessler Support]

Last change on Feb 24, 2016 9:43:16 AM by  Luciano Lingnau [Paessler Support]



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.