• Forums
    • Public Forums
      • Community Connect
      • Dynatrace
        • Dynatrace Open Q&A
      • Application Monitoring & UEM
        • AppMon & UEM Open Q&A
      • Network Application Monitoring
        • NAM Open Q&A
  • Home /
  • Public Forums /
  • Application Monitoring & UEM /
  • AppMon & UEM Open Q&A /
avatar image
Question by gil g. · Jul 06, 2014 at 02:00 AM ·

Cassandra statistics

Hi All, 

 

What would be the best way to get the following information from Cassandrda ? 

Write Requests (rate, count, latency)

Read Requests (rate, count, latency)

Pending Write Operations (flushes, post flushes, write requests, replication of write)

Pending Read Operations (read requests, read repair tasks, compactions)

Pending Cluster Operations (manual repair tasks, gossip tasks, hinterd handoff, internal responses, migrations, misc tasks, request responses)

Compactions

Row/Key Cache (hit ratio, requests count)

Local Writes (rate, count, latency)

Local Reads (rate, count, latency)

SSTable (size, count)

Bloom Filter (space used, false positives ratio)

 

Gil.

Comment

People who like this

0 Show 0
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

6 Replies

  • Sort: 
  • Most voted
  • Newest
  • Oldest
avatar image

Answer by Edward W. · Feb 05, 2015 at 10:56 AM

I have noticed in the DataStax documentation under "Cluster Metric Keys"

http://www.datastax.com/documentation/opscenter/5.0/api/docs/metrics.html#metrics-attribute-key-lists

measurements like "read-ops" and "write-ops"  I am not able to find similarly named metrics in Dynatrace when trying to create a new measure using custom JMX time measures  Is is possibly that Dynatrace is not using the default names that DataStax is using, or is Dynatrace only seeing a fraction of the measures DataStax supports for monitoring Cassandra 

Happy to hear your thoughts 

 

Ed

Comment

People who like this

0 Show 0 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

avatar image

Answer by Andreas G. · Jan 19, 2015 at 07:13 PM

Hi

Please download the Cassandra Fastpack that I've linked to: Apache Cassandra Fastpack

Once you have installed that FastPack you have new pre-configured JMX Metrics available in all of your System Profiles. Simply open your System Profile - click on Measures and then on Create. You will find the new measures that Richard showed in the screenshot under Server-Side Performance->Agent based Measures->Cassandra Basics

Andi

Comment

People who like this

0 Show 0 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

avatar image

Answer by Kayvan K. · Jan 19, 2015 at 09:39 AM

sorry -  how do you get this information from dynatrace? We installed dynatrace on our Cassandra hosts as well as on our application hosts that are making calls to Cassandra, but we are only able to capture basic host level monitoring  Is there some configuration that we might have missed?

This is what we have for our sensor placement.  We are getting a couple hints;  change the placement of sensor packs and NoSQL Cassandra Database hints .   not sure what each of these refers to or where these configurations are located.  Any help would be great. 

 

 

 

Comment

People who like this

0 Show 0 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

avatar image

Answer by Andreas G. · Jul 16, 2014 at 01:46 AM

Yes. dynaTrace has built-in support to capture ANY JMX Metric. Check out the following doc page: Using Custom JMX and PMI Measures in Charts

Comment

People who like this

0 Show 0 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

avatar image

Answer by gil g. · Jul 16, 2014 at 01:35 AM

Andi, 

 

Just found out that competitive tools are actually using JMX to collect this data. Can we implement the same easily ? 

 

Gil.

Comment

People who like this

0 Show 1 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

avatar image Rick B. · Jul 16, 2014 at 02:20 AM 0
Share

The dynaTrace Fastpack for Cassandra Andi linked above includes many of the JMX metrics with zero-configuration needed:

avatar image

Answer by Andreas G. · Jul 09, 2014 at 08:44 PM

Hi. I am not the expert on Cassandra and therefore forwarded this internal. In the meantime you may however want to check out the following two links

a) http://apmblog.compuware.com/2011/09/20/cassandra-write-performance-a-quick-look-inside/

b) dynaTrace FastPack for Cassandra

Andi

Comment

People who like this

0 Show 0 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

How to get started

First steps in the forum
Read Community User Guide
Best practices of using forum

NAM 2019 SP5 is available


Check the RHEL support added in the latest NAM service pack.

Learn more

LIVE WEBINAR

"Performance Clinic - Monitoring as a Self Service with Dynatrace"


JANUARY 15, 3:00 PM GMT / 10:00 AM ET

Register here

Follow this Question

Answers Answers and Comments

4 People are following this question.

avatar image avatar image avatar image avatar image

Forum Tags

dotnet mobile monitoring load iis 6.5 kubernetes mainframe rest api dashboard framework 7.0 appmon 7 health monitoring adk log monitoring services auto-detection uem webserver test automation license web performance monitoring ios nam probe collector migration mq web services knowledge sharing reports window java hybris javascript appmon sensors good to know extensions search 6.3+ server documentation easytravel web dashboard kibana system profile purelytics docker splunk 6.1 process groups account 7.2 rest dynatrace saas spa guardian appmon administration production user actions postgresql upgrade oneagent measures security Dynatrace Managed transactionflow technologies diagnostics user session monitoring unique users continuous delivery sharing configuration alerting NGINX splitting business transaction client 6.3 installation database scheduler apache mobileapp RUM php dashlet azure purepath agent 7.1 appmonsaas messagebroker nodejs 6.2 android sensor performance warehouse
  • Forums
  • Public Forums
    • Community Connect
    • Dynatrace
      • Dynatrace Open Q&A
    • Application Monitoring & UEM
      • AppMon & UEM Open Q&A
    • Network Application Monitoring
      • NAM Open Q&A