About DSE Performance Service
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, About DataStax Studio 6.8, 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 OpsCenter Performance Service provides visual monitoring of diagnostics collected through the DSE Performance Service, displays alerts, and provides recommendations for optimizing cluster performance.
The available diagnostic tables are listed on these pages:
*DSE Performance Service diagnostic table reference *DSE Search Performance Service diagnostic table reference
Sample output from querying thread pool statistics:
SELECT * FROM dse_perf.thread_pool;
Result:
