About DSE Performance Service
The DSE Performance Service automatically collects and organizes performance diagnostic information into a set of data dictionary tables that can be queried with CQL.
The DSE Performance Service automatically collects and organizes
performance diagnostic information from DSE, DSE Search, and
DSE Analytics into a set of data dictionary tables. These tables are stored in the
dse_perf keyspace and can be queried with CQL using any CQL-based
utility, such as cqlsh, , or any application using a
DataStax driver.
Use this service to obtain database metrics and optimize performance and fine-tune DSE
Search. Examples include:
- Identify slow queries on a cluster to easily find and tune poorly performing queries.
- View latency metrics for tables on all user (non-system) keyspaces.
- Collect per node and cluster wide lifetime metrics by table and keyspace.
- Obtain recent and lifetime statistics about tables, such as the number of SSTables, read/write latency, and partition (row) size.
- Track read/write activity on a per-client, per-node level for both recent and long-lived activity to identify problematic user and table interactions.
- Detect bottlenecks in DSE Search.
- Monitor the resources used in a DSE Analytics cluster.
- Monitor particular DSE Analytics applications.
The available diagnostic tables are listed on these pages:
Sample output from querying thread pool statistics:
SELECT * FROM dse_perf.thread_pool;Result:
