This article is contributed. See the original author and article here.

We are excited to announce the public preview of Azure Data Explorer Insights!
ADX Insights (Azure Monitor for Azure Data Explorer) provides comprehensive monitoring of your clusters by delivering a unified view of your cluster performance, operations, and usage.


Built on the Azure Monitor Workbooks platform, ADX insights offers:


 



  • At scale perspective: showing a snapshot view of the clusters’ primary metrics to easily track performance, ingestion, and export operations. Unsustainable values are highlighted in orange. You can drill down to the “at-resource” view by clicking on the cluster name.
    1-ingestion-performance.png

  • At-resource perspective: drill-down analysis of a particular Azure Data Explorer cluster based on metrics and platform usage logs.
    With this view, you can:

    • Identify query lookback patterns per table and compare them to the table’s cache policy.
      The Cache tabThe Cache tab

    • Identify tables that are used by the most queries. 

    • Identify unused tables or redundant cache policy periods.

    • Find which tables are consuming the most space in the cluster

    • Track data growth history by table size, hot data, and the number of rows over time.
      The Tables tabThe Tables tab

    • Identify which users and applications are sending the most queries or consuming the most CPU and memory.

    • Find changes in the number of queries by user and track the number of unique users over time.

    • See top users by command and query count and identify top users by the number of failed queries.

    • See the query count, CPU, and memory consumption over time.
      The Usage tabThe Usage tab

    • Get a summary of active Advisor recommendations and resource health status.
      The Overview tabThe Overview tab

    • Explore multiple key metrics on one page and discover correlations between them.
      The Key Metrics tabThe Key Metrics tab




Azure Monitor for Azure Data Explorer is now available in the Azure Monitor and Azure Data Explorer blades in the Azure portal. We look forward to hearing your feedback on the new experience.
To learn more, see the ADX Insights documentation.



 

Brought to you by Dr. Ware, Microsoft Office 365 Silver Partner, Charleston SC.