This message was deleted.

Seems like the sjk jar in not in your classpath?

even when i provide full path still see this issue . if i try to change permissions then it will say jar got corrupted

try re-downloading the jar:

curl -L -o sjk.jar '<https://repo1.maven.org/maven2/org/gridkit/jvmtool/sjk-plus=LATEST>'

i did multiple times .

hmm you’re right. The curl command from the article is resulting in a few bytes of the downloaded jar, so the resulting jar does seem corrupt. Try pointing to the specific jar for now:

curl -L -o sjk.jar '<https://repo1.maven.org/maven2/org/gridkit/jvmtool/sjk-plus/0.21/sjk-plus-0.21.jar>'

ok ..thanks let me try this

I'll look in to updating the KBs, thanks for pointing this out.

Thanks @Ben Krug i am able to generate flame graph but how can i interpret that . we are noticing some queries are taking long time to process so wanted to check what is causing this issue

We don't have much on that, I only find a few notes in the KB you linked to earlier (here). I think it takes a decent amount of knowledge about the code, beyond the tips in the KB.

It random ones but I do see load avg on those historicals are around 20%

Could be intensive queries, but one thing that often helps is compaction for better segment sizes and rollup, if you haven't already done that. (But that's a stab in the dark.)

no these are very small queries and datasource it run against is also very less few 100 GB