General availability: Azure Data Explorer Insights
Published date: 27 October, 2021
Get comprehensive monitoring of your Azure Data Explorer Clusters along with a unified view of your Azure Data Explorer performance, cache, ingestions and usage by using Azure Data Explorer Insights. Built on the Azure Monitor Workbooks platform, Azure Data Explorer insights offers:
- At scale perspective, displaying a snapshot view of performance based on the clusters' main metrics, to easily track performance of queries, ingestion, and export operations.
- Drill-down analysis of a particular Azure Data Explorer cluster to:
- Monitor the cluster with a unified view of the cluster's key metrics, including metrics for queries, ingestion, and export operations.
- Identify query look back patterns per table and compare it to the cache policy.
- Identify tables that are used by the most queries and tables that are not queried.
- Track growth history by table size, hot data, and the number of rows over time.
- Inspect the top CPU consumers.
- Find changes in the number of queries by user and track the number of unique users over time.
- Identify top users by failed queries.
- See top users by command and query count.
- See the query count, CPU, and memory consumptions over time.
- Monitor the status of batching ingestion operations, including the ingestion result, latency and amount of data processed.
- Better understand how batches are generated during ingestion process.
- Monitor materialized view's health and usage by database.
- Get a summary of active Advisor recommendations and Resource Health status.
- Customizable view, allowing you to change which metrics you want to see, modify or set thresholds that align with your limits, and save your own workbook.
Azure Data Explorer Insights is available now in the Azure Monitor and the Azure Data Explorer resources in the Azure portal.
For more information please visit the Azure Data Explorer Insights documentation.