Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Universal Device Poller - per second calculations.

I need to make 'per second' calculations on UNDPs. So I'd need to poll an oid then poll it again in 10 seconds, work out the delta and divide by 10. Is this possible as it's a requirement for a lot of the data I need to graph.

Find more posts tagged with

Accepted answers

All comments

FormerMember

Counter pollers do that for you. They work out the delta and divides by the number of seconds between the two polls. A poller currently uses the node(or interface) statistics polling interval, so if you're looking for shorter time periods, you'll want to drop this down. I wouldn't recommend dropping it to 10 seconds though. That's a little extreme.

Will this take care of what you're trying to do?

pdjhh

Yes that sounds perfect. So I could set the polling interval to 1 minute then use a transform to divide by 60 to get per second?

FormerMember

No need to set up a transform. Open the "Advanced options" section and change your MIB Value Type to counter and the UnDP will automatically do it for you. Is there a reason you need such a short statistics polling interval? Such a short interval(over the default) will probably have a pretty hefty impact on the performance of the server.

pdjhh

My resultant NEEDS to be per second but if I don't want to poll that often then I'll have to transform it won't I? The licensing on the appliance I'm monitoring is based on new connections per second. I can get new connections from the mib so thought I'd have to run a counter on that then divide by 60 to get the per second stat I need?

pdjhh

I managed to work out how that operates and get the correct results calculated per second thanks. The advanced options are not clear at all but I got there in the end. What about more complex calculation? I've got this one from F5.

Performance Graph (Configuration utility)	Graph Metrics	Required SNMP OIDs
SSL TPS	SSL TPS	sysClientsslStatTotNativeConns (.1.3.6.1.4.1.3375.2.1.1.2.9.6)
SSL TPS	SSL TPS	sysClientsslStatTotCompatConns (.1.3.6.1.4.1.3375.2.1.1.2.9.9)
SSL TPS	SSL TPS	sysServersslStatTotNativeConns (.1.3.6.1.4.1.3375.2.1.1.2.10.6)
SSL TPS	SSL TPS	sysServersslStatTotCompatConns (.1.3.6.1.4.1.3375.2.1.1.2.10.9)

For example, to collect data on SSL transactions for the SSL TPS graph metric, follow these steps.

1.	Poll the OID sysClientsslStatTotNativeConns (.1.3.6.1.4.1.3375.2.1.1.2.9.6).

2.	Poll the OID sysClientsslStatTotCompatConns (.1.3.6.1.4.1.3375.2.1.1.2.9.9).

3.	Add the two values together. This results in the value sysClientsslStatTotConns1.

4.	Poll the two OIDs again, within ten seconds of the previous polls (shown in steps 1 and 2).

Note: Although this example uses an interval of ten seconds, the interval can actually be any duration that you choose.

5.	Again, add the two values together. This results in the value sysClientsslStatTotConns2.

6.	Calculate the delta of the two sums:

7.	Calculate the actual value of the SSL TPS graph metric using the calculation shown in Table 16.16. An example of the <interval> value is 10.

Table 16.16 Required calculations for interpreting metrics on SSL TPS


Performance Graph (Configuration utility)	Graph Metric	Required calculations for SSL TPS
SSL TPS	SSL TPS	<DeltaClientsslStatClientTotConns> / <interval>

Possible do you think?

NasaGeek

I'm not sure about Orion doing that, but you can easily do it with cron, Perl and Netsnmp, and if you wanted to graph it you could throw the results to MRTG. I do several things like this that you just can't do with Orion.

Perhaps Orion will become more powerful and allow us to give it results that it can then graph. You can the create a script to do anything you want, and not be limited to the what the application can poll.

pblatz

OK,

Orion reports the Delta for each of the OIDs the UnDP records.
Here is what I have so far, will let you know how it works out.
1. sysClientsslStatTotCompatConns (1.3.6.1.4.1.3375.1.1.2.9.9)
  1. Advanced Options: Counter, Unit: Connections, Time Frame: Second, Poll Type: Node, Get Type: Get Next
  2. Keep Historical: Yes
  3. Group: F5
2. sysClientsslStatTotNativeConns (1.3.6.1.4.1.3375.1.1.2.9.6)
  1. Advanced Options: Counter, Unit: Connections, Time Frame: Second, Poll Type: Node, Get Type: Get Next
  2. Keep Historical: Yes
  3. Group: F5
3. Transform: ClientSSLConnsperSecond
  1. Keep Historical
  2. Formula: ({sysClientsslStatTotCompatConns}+{sysClientsslStatTotNativeConns})/600 <Node Polling Interval in Seconds>
  3. Web Assigned to F5 Node as Chart and Graph

This reports a close representation of the SSL TPS and the Client SSL Conns/s graphs available from the F5 GUI with the capability to alert at thresholds, an not just when the license limit is reached.

NOTE TO SW Dev: Would love to be able to specify the Y-Axis units in Transform Results.

A_Dutta

Hi pblatz,

i am new to solarwinds and having problems with transforms.

Just saw your post on transforms. Could you please explain why you are diving the total summation (({sysClientsslStatTotCompatConns}+{sysClientsslStatTotNativeConns})/) by 600? According to your steps 2.1 and 2.2 Solarwinds has already calculated the Number of connections per second, meaning that division by 600 has already been performed for a 10 min interval., so is there any need to divide it again by 600 in step 2.3.2?