Cassandra
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.
Hardware
The Hardware tab is selected by default. The following widgets are displayed.
| Widget Name | Description |
|---|---|
| Disk usage | Disk usage |
| CPU usage | CPU utilization of host |
| Memory usage | Memory utilization of host |
| Network I/O | Network input/output data in MB |
| Event details | Database Background Events List |
Query Performance
Clicking the Query Performance tab and selecting the threshold from the Query threshold drop-down list displays the following screen.
note
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.
Connections
Clicking the Connections tab displays the following widgets as in the following screen.
| Widget Name | Description |
|---|---|
| Connections & Sessions | Database number of connections & sessions count |
| Heartbeat | Count to check database is alive and responding |
| Session details | Session details having users and queries count with time |
Metrics
Clicking the Metrics tab displays the following widgets.
| Widget Name | Description |
|---|---|
| Load | Number of requests |
| Database Size | Database size |
| SS Table & Pending Hints | Building blocks of the total data stored in the database and request pending hints count |
| Latency | Read, write and scan latency of request |
| Keyspace Count | Number of keyspace count |
| Prepared Statements | Number of prepared statements |
| Task | Number of tasks |
| Local Read,Scan,Write | latency of requests in milliseconds |
| Cache | Counters and keys cache hit rate |
| Compaction | Compaction size in and out in MB |