Abstract: A clustered application infrastructure troubleshooting system performs a set of queries on a database of infrastructure data to retrieve a set of metrics for each of a plurality of issues. For each issue, the system analyzes a corresponding set of metrics based on detection criteria associated with the issue to detect one or more issues. The system identifies a set of remediation steps for resolving each issue and infrastructure objects affected by each of the one or more detected issues. The system performs queries on the database of infrastructure data to retrieve a set of data associated with the affected infrastructure objects. The system generates a GUI with advisories corresponding to the detected issues. Responsive to the user selecting an advisory, the system causes the GUI to present the remediation steps and the set of data associated with the one or more affected infrastructure objects corresponding to the selected advisory.

Abstract: Techniques for organizing and storing metrics for efficient querying is disclosed. A data collection system is implemented to receive, from a device, an original dataset comprising metrics of a component of a clustered application environment and metadata associated with the metrics. Based on the metrics, a tree structure containing a plurality of nodes is populated with the metrics and metadata. The data collection system generates an updated dataset containing the metrics, associated labels, and enriched labels based on the metadata. The updated dataset is stored within a database table. The data collection system receives a query for metrics. In response to receiving the query, the data collection system generates a result set containing at least a subset of the data values in the database table and at least one enriched label.