Use the following procedure for monitoring the Cassandra database.
- Navigate to Database monitoring on the left pane.
- Select Cassandra from the Select database drop-down list.
- Select a service from the Select service drop-down list.
The following screen appears along with the various available tabs.
The Hardware tab is selected by default. The following widgets are displayed.
|CPU utilization of host
|Memory utilization of host
|Network input/output data in MB
|Database Background Events List
Clicking the Query Performance tab and selecting the threshold from the Query threshold drop-down list displays the following screen.
You can download the Query Performance table in PDF format by clicking the icon. Only the top 100 entries are downloaded if there are more than 100 entries for downloading.
Clicking the Connections tab displays the following widgets as in the following screen.
|Connections & Sessions
|Database number of connections & sessions count
|Count to check database is alive and responding
|Session details having users and queries count with time
Clicking the Metrics tab displays the following widgets.
|Number of requests
|SS Table & Pending Hints
|Building blocks of the total data stored in the database and request pending hints count
|Read, write and scan latency of request
|Number of keyspace count
|Number of prepared statements
|Number of tasks
|latency of requests in milliseconds
|Counters and keys cache hit rate
|Compaction size in and out in MB