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:

Sample output from querying thread pool statistics:

SELECT * FROM dse_perf.thread_pool;


prfSvc output

Was this helpful?

Give Feedback

How can we improve the documentation?

© 2024 DataStax | Privacy policy | Terms of use

Apache, Apache Cassandra, Cassandra, Apache Tomcat, Tomcat, Apache Lucene, Apache Solr, Apache Hadoop, Hadoop, Apache Pulsar, Pulsar, Apache Spark, Spark, Apache TinkerPop, TinkerPop, Apache Kafka and Kafka are either registered trademarks or trademarks of the Apache Software Foundation or its subsidiaries in Canada, the United States and/or other countries. Kubernetes is the registered trademark of the Linux Foundation.

General Inquiries: +1 (650) 389-6000, info@datastax.com