Description

This template monitors Cassandra column family related metrics. It is applicable on devices containing Cassandra application.

Prerequisites

Java should be installed on the device. Gateway should be up and running. The device should be reachable from Gateway. The device should be in managed state.

How to Apply:

For Cassandra, we have Instance Based Monitoring or Component Discovery Monitoring . In order to do that, we should add the following custom parameter:

application.component.name : ColumnFamily

Create different monitors for different components in Instance based monitoring.

Only one component is allowed per monitor in Instance based monitoring.

We have three different types of Component Discovery Monitoring. They are:

For a single component :

ALL : ALL your instances will be monitored.

Expression : The Instance Names that match the expression will be monitored.

Manual Selection : With this option, you can select the desired instances while applying templates to the device.

Metric Parameters

Metric Parameters
ParameterDescription
Frequency
  • Frequency is the interval in which you want to probe and collect metric data from the target device/resource
  • Frequency is defined in minutes (min).
  • Warning ThresholdIf the metric value satisfies the condition defined along with Warning Threshold value, then a notification is sent to the user.
    Critical ThresholdIf the metric value satisfies the condition defined along with Critical Threshold value, then a notification is sent to the user.
    AlertThe alert value can be set to either Yes or No. If it is Yes, then an alert message is sent to the user.

    Metrics

    cassandra.columnfamily.overall.range_latency.75th_percentile

    Metric Details

    Metric Details
    Applicable forDevice
    DescriptionCassandra Columnfamily 75th Percentile Overall Range Latency.
    CategoryApplication
    Collector TypeGateway
    Monitor NameCassandra ColumnFamily Monitor
    Unitmicrosec

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    cassandra.columnfamily.overall.range_latency.95th_percentile

    Metric Details

    Metric Details
    Applicable forDevice
    DescriptionThe local range request latency - p95.
    CategoryApplication
    Collector TypeGateway
    Monitor NameCassandra ColumnFamily Monitor
    Unitmicrosec

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    cassandra.columnfamily.overall.range_latency.one_minute_rate

    Metric Details

    Metric Details
    Applicable forDevice
    DescriptionThe number of local range requests.
    CategoryApplication
    Collector TypeGateway
    Monitor NameCassandra ColumnFamily Monitor
    Unitcount

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    cassandra.columnfamily.overall.read_latency.75th_percentile

    Metric Details

    Metric Details
    Applicable forDevice
    DescriptionThe local read latency - p75.
    CategoryApplication
    Collector TypeGateway
    Monitor NameCassandra ColumnFamily Monitor
    Unitmicrosec

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    cassandra.columnfamily.overall.read_latency.95th_percentile

    Metric Details

    Metric Details
    Applicable forDevice
    DescriptionThe local read latency - p95.
    CategoryApplication
    Collector TypeGateway
    Monitor NameCassandra ColumnFamily Monitor
    Unitmicrosec

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    cassandra.columnfamily.overall.read_latency.99th_percentile

    Metric Details

    Metric Details
    Applicable forDevice
    DescriptionThe local read latency - p99.
    CategoryApplication
    Collector TypeGateway
    Monitor NameCassandra ColumnFamily Monitor
    Unitmicrosec

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    cassandra.columnfamily.overall.read_latency.one_minute_rate

    Metric Details

    Metric Details
    Applicable forDevice
    DescriptionThe number of local read requests.
    CategoryApplication
    Collector TypeGateway
    Monitor NameCassandra ColumnFamily Monitor
    Unitcount

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    cassandra.columnfamily.overall.write_latency.75th_percentile

    Metric Details

    Metric Details
    Applicable forDevice
    DescriptionThe local write latency - p75.
    CategoryApplication
    Collector TypeGateway
    Monitor NameCassandra ColumnFamily Monitor
    Unitmicrosec

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    cassandra.columnfamily.overall.write_latency.95th_percentile

    Metric Details

    Metric Details
    Applicable forDevice
    DescriptionThe local write latency - p95.
    CategoryApplication
    Collector TypeGateway
    Monitor NameCassandra ColumnFamily Monitor
    Unitmicrosec

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    cassandra.columnfamily.overall.write_latency.99th_percentile

    Metric Details

    Metric Details
    Applicable forDevice
    DescriptionThe local write latency - p99.
    CategoryApplication
    Collector TypeGateway
    Monitor NameCassandra ColumnFamily Monitor
    Unitmicrosec

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    cassandra.columnfamily.overall.write_latency.one_minute_rate

    Metric Details

    Metric Details
    Applicable forDevice
    DescriptionThe number of local write requests.
    CategoryApplication
    Collector TypeGateway
    Monitor NameCassandra ColumnFamily Monitor
    Unitcount

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    cassandra.columnfamily.live_disk_space_used

    Metric Details

    Metric Details
    Applicable forDevice
    DescriptionThe disk space used by "live" SSTables (only counts in use files).
    CategoryApplication
    Collector TypeGateway
    Monitor NameCassandra ColumnFamily Monitor
    UnitBytes

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    cassandra.columnfamily.view_read_time.75th_percentile

    Metric Details

    Metric Details
    Applicable forDevice
    DescriptionThe time taken during the local read of a materialized view update - p75.
    CategoryApplication
    Collector TypeGateway
    Monitor NameCassandra ColumnFamily Monitor
    Unitmicrosec

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    cassandra.columnfamily.view_read_time.95th_percentile

    Metric Details

    Metric Details
    Applicable forDevice
    DescriptionThe time taken during the local read of a materialized view update - p95.
    CategoryApplication
    Collector TypeGateway
    Monitor NameCassandra ColumnFamily Monitor
    Unitmicrosec

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    cassandra.columnfamily.view_read_time.one_minute_rate

    Metric Details

    Metric Details
    Applicable forDevice
    DescriptionThe number of local reads for materialized view updates.
    CategoryApplication
    Collector TypeGateway
    Monitor NameCassandra ColumnFamily Monitor
    Unitrps

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    cassandra.columnfamily.bloomfilter.falseratio

    Metric Details

    Metric Details
    Applicable forDevice
    DescriptionThe ratio of Bloom filter false positives to total checks.
    CategoryApplication
    Collector TypeGateway
    Monitor NameCassandra ColumnFamily Monitor
    Unit%

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    cassandra.columnfamily.bytesflushed.count

    Metric Details

    Metric Details
    Applicable forDevice
    DescriptionThe amount of data that was flushed since (re)start.
    CategoryApplication
    Collector TypeGateway
    Monitor NameCassandra ColumnFamily Monitor
    UnitBytes

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    cassandra.columnfamily.compaction_bytes_written_count

    Metric Details

    Metric Details
    Applicable forDevice
    DescriptionCassandra Columnfamily Compaction Bytes Written Count
    CategoryApplication
    Collector TypeGateway
    Monitor NameCassandra ColumnFamily Monitor
    UnitBytes

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    cassandra.columnfamily.compression_ratio

    Metric Details

    Metric Details
    Applicable forDevice
    DescriptionThe compression ratio for all SSTables. ! A low value means a high compression contrary to what the name suggests. Formula used is: 'size of the compressed SSTable / size of original'
    CategoryApplication
    Collector TypeGateway
    Monitor NameCassandra ColumnFamily Monitor
    Unit%

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    cassandra.columnfamily.row_cache_hit_out_of_range_count

    Metric Details

    Metric Details
    Applicable forDevice
    DescriptionThe number of row cache hits that do not satisfy the query filter and went to disk.
    CategoryApplication
    Collector TypeGateway
    Monitor NameCassandra ColumnFamily Monitor
    Unitcount

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    cassandra.columnfamily.row_cache_hit.count

    Metric Details

    Metric Details
    Applicable forDevice
    DescriptionThe number of row cache hits.
    CategoryApplication
    Collector TypeGateway
    Monitor NameCassandra ColumnFamily Monitor
    Unitcount

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    cassandra.columnfamily.row_cache_miss_count

    Metric Details

    Metric Details
    Applicable forDevice
    DescriptionThe number of table row cache misses.
    CategoryApplication
    Collector TypeGateway
    Monitor NameCassandra ColumnFamily Monitor
    Unitcount

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    cassandra.columnfamily.pending_compactions

    Metric Details

    Metric Details
    Applicable forDevice
    DescriptionThe number of pending compactions.
    CategoryApplication
    Collector TypeGateway
    Monitor NameCassandra ColumnFamily Monitor
    Unitcount

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    cassandra.columnfamily.pending_flushes

    Metric Details

    Metric Details
    Applicable forDevice
    DescriptionThe number of pending flushes.
    CategoryApplication
    Collector TypeGateway
    Monitor NameCassandra ColumnFamily Monitor
    Unitcount

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    cassandra.db.columnfamilies.droppable_tombstone_ratio

    Metric Details

    Metric Details
    Applicable forDevice
    DescriptionThe estimate of the droppable tombstone ratio.
    CategoryApplication
    Collector TypeGateway
    Monitor NameCassandra ColumnFamily Monitor
    Unit%

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    cassandra.columnfamily.mean_row_size

    Metric Details

    Metric Details
    Applicable forDevice
    DescriptionThe average size of compacted rows.
    CategoryApplication
    Collector TypeGateway
    Monitor NameCassandra ColumnFamily Monitor
    UnitBytes

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph

    cassandra.columnfamily.max_row_size

    Metric Details

    Metric Details
    Applicable forDevice
    DescriptionThe size of the largest compacted row.
    CategoryApplication
    Collector TypeGateway
    Monitor NameCassandra ColumnFamily Monitor
    UnitBytes

    Possible Inputs

    Possible Inputs
    MetricInput ValueRange of Values
    Frequency51 – 1440 (mins)
    Filter
    Warning Operator
    Warning Threshold
    Warning Repeat Count
    Critical Operator
    Critical Threshold
    Critical Repeat Count
    AlertNoYes/No
    Graph (Yes/No)YesYes/No

    Sample Output

    No graph