Performance Service Overview

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 OpsCenter Performance Service combines OpsCenter metrics with CQL-based diagnostic tables populated by the DSE Performance Service to help understand, tune, and optimize cluster performance.

Performance Service overview panels

Enable the performance metrics panels and visually analyze the results within OpsCenter. Currently, the performance overview panels include:

  • Slow Queries: Identify slow queries on a cluster to easily find and tune poorly performing queries.

  • Table Metrics: Displays metrics to discover and diagnose poorly performing tables.

  • Thread Pool Statistics: Displays information about Cassandra system-level details such as thread pools.

opscPerfServiceOV

Each panel contains a read-only high-level summary with pertinent sortable columns. Clicking on the title bar of a panel opens its expanded performance page:

opscPerfServiceSlowQueriesDetails

Alerts panel

On each performance page in OpsCenter, an alerts panel feed displays triggered alerts. Any alerts you configure specifically for your environment appear in the panel.

Alerts for the OpsCenter Performance Service are not pre-configured.

For guidance on configuring alerts for Performance Service, refer to the sample setup scenario sections:

opscPSalertsPanel

Recommendations panel

On each performance page in OpsCenter, a panel provides recommendations to rectify and improve performance issues.

opscPSrecommPanel

Best Practice Service - Performance Service Advisors

The OpsCenter Performance Service integrates with the Best Practice Service. Any rules that fail send an alert to the relevant Alerts panel in each performance page, and generate suggestions to remediate issues in the Recommendations panels. The Best Practice Service monitors rules configured for the Performance Service Advisors:

opscPSBPslowQueriesAdvisor

By default, all rules are enabled and scheduled to run every hour. Adjust the rule configuration to suit the requirements of your environment.

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