Monitoring CockroachDB

The CockroachDB sensor is automatically deployed and installed after you install the Instana agent.

Support information

To make sure that the CockroachDB sensor is compatible with your current setup, check the following support information sections:

Supported versions and support policy

The current version of the CockroachDB sensor will only connect to instances started with the --insecure flag. The following table shows the latest supported version and support policy:

Table 1. Latest supported version and support policy
Technology Support policy Latest technology version Latest supported version
CockroachDB 45 days 24.3.3 24.3.3

For more information about the support policy, see Support strategy for sensors.

Configuration

An agent natively monitors the CockroachDB sensor, and its configuration is optional. You can use the CockroachDB sensor for custom polling.

If no specific polling interval is provided, the default polling interval is 10 seconds.

# Cockroach DB Sensor
com.instana.plugin.cockroachdb:
  enabled: true
  poll_rate: 30 #Values are in seconds. Default Value 10 Sec.

Metrics collection

To view the metrics, select Infrastructure in the sidebar of the Instana User interface, click a specific monitored host, and then you can see a host dashboard with all the collected metrics and monitored processes.

Node-Level

Configuration data

  • Node Id
  • Cluster Id
  • Cache
  • Status

Performance metrics

  • SQL Connection Count
  • SQL Reads
  • SQL Writes
  • Total Ranges
  • Underreplicated Ranges
  • Unavailable Ranges
  • SQL Latency vs. Queries
    • Latency 99th
    • Queries
  • Queries
    • Select
    • Insert, Update, Delete
  • SQL Latency
    • 50th percentile
    • 75th percentile
    • 90th percentile
    • 99th percentile
    • max percentile
  • Go Memory
    • Allocated
    • Total
  • Cgo Memory
    • Allocated
    • Total
  • Disk IOPS in progress
  • Disk read bytes
  • Disk write bytes
  • Disk read Ops
  • Disk write Ops
  • Network receive bytes
  • Network send bytes
  • Statistics per store
    • Store Id
    • Capacity
    • Available
    • Used
    • Queries/s
    • Writes/s

Cluster-level

Configuration data

  • Cluster Id
  • Live nodes
  • Suspect nodes
  • Dead nodes

Performance metrics

  • SQL Connection Count
  • SQL Reads
  • SQL Writes
  • Total Ranges
  • Underreplicated Ranges
  • Unavailable Ranges
  • SQL Latency
    • 50th percentile
    • 75th percentile
    • 90th percentile
    • 99th percentile
    • max percentile
  • Disk IOPS in progress
  • Disk read bytes
  • Disk write bytes
  • Disk read Ops
  • Disk write Ops
  • Network receive bytes
  • Network send bytes