I see there are other threads on this topic, but its still not exactly clear to me which one I would use for what I am after. I am using the JMX Editor to try and capture the database ActiveConnectionsCurrentCount for WLS datasources. When setting this up though there is SUM and Count. I am not exactly sure what the difference is and which one I would use in this situation?
Answer by Julius L. ·
I think you want to use COUNT for this metric. The metric will then reflect the actual count of the collected JMX attribute in the given point in time.
If you choose, SUM then as it says, it will sum the measured value. This would reflect the total number of connections. This might not be precise since the measurement is done every minute and you won't have information about connections that have been opened and closed between measurement times.
Plugin similar to DB Query 1 Answer
Dynatrace with TIBCO BusinessWorks 1 Answer