Combining Performance Counters

In an effort to track TCP packet loss we are monitoring TCPv4 SegmentsRetransmitted/Sec and SegmentsSent/Sec. In order to determine network packet loss, we need to divide SegmentsRetransmitted/Sec/SegmentSent/sec. I'm able to do this with a SQL report, however for tracking purposes we're looking to do a new monitor. Is there a way to use a SAM component monitor to combine these values? I've been unable to find any thing at this point. I tried using the SQL User Experience Monitor, but since the Initial Catalog is required, I've been unable to use the monitor to remotely connect to the Orion database and calculate the value based on the node the monitor is assigned to. Is what I'm looking for something that's even possible in SAM?

Find more posts tagged with

performance counters

sam components

Accepted answers

All comments

aLTeReGo

Yes, this is something which could be done using the SQL User Experience Monitor. Simply write your query to select the last polled value of each metric and perform your mathematical function on the result. Note it sounds easier than it actually is, but if you're decent with SQL it should not be too difficult.

mharvey

yeah I tried this, but I ran into issues with assigning it to other nodes to calculate those values. It kept trying to run against the assigned node as the SQL server rather than the Orion SQL server. I've been trying my hand at the ODBC user experience monitor, but can't seem to be able to pass variables in the Query to isolate to the node the monitor is assigned to as well.

aLTeReGo

That is correct. The SQL User Experience Monitor must be assigned to the node hosting the SQL database, so these metrics will always appear to be coming from the Orion SQL server in your case. A fairly simple solution if that's untenable would be to use the ODBC User Experience Monitor instead, since you can assign it to any node but change what server the query is executed against in the ODBC connection string.

mharvey

Since I'm needed the calculation to be done individually for each system the other counters are collecting on, I'm now working with ODBC, but have run into an issue of trying to pass a variable in a query. Passing Variables within a query. Is it possible to pass a variable such as ${NodeName} or ${IP} in the query in order for it to pull just the data for the node it's assigned to?