DQL
Questions about Dynatrace Query Language
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Resolve JVM GC Collection Time and Count Discrepancies Using DQL

koushickpatel
Newcomer

Hi,

I am trying set up a query for jvm gc.collection_time & gc.collection_count.

timeseries avg(dt.runtime.jvm.gc.collection_time), by: { host.name }, filter: { (host.name == xxxx)}

timeseries avg(dt.runtime.jvm.gc.collection_count), by: { host.name }, filter: { (host.name == xxxx)}

My value are not matching when  check from comand line using jstat

garbage collection count 70164
garbage collection time 1182.307

koushickpatel_0-1739281134872.png

where as in dyntrace the value are not even close

koushickpatel_1-1739281223281.png

 

 

 

 

 

3 REPLIES 3

AravindhanV
Advisor

hiya, 

Looking with your timeseries metric configuration, its understood that you are using the average to calculate the GC count and time. whereas with the jstat command it will be more of sum or the sum of samples. So, would recommend to change the aggregation  to sum and validate once. 

timeseries sum instead of timeseries avg 

Thanks

aravind

We tried sum but the value is still not matching

IzabelaRokita
Community Team
Community Team

Hey @koushickpatel ,
I just wanted to check in and see if you still need help with this. If so, I’d be happy to look into it for you! 😊
Please let me know what works best for you.

Featured Posts