How to monitor the materialize cache size

Jianbo Yao (Centific Technologies Inc) 20 Reputation points Microsoft Vendor
2023-10-20T06:03:47.68+00:00

Kusto function materialize has a limitation of 5GB size. This info was introduced in this article :https://learn.microsoft.com/en-us/azure/data-explorer/kusto/query/materializefunction

Materialize has a cache size limit of 5 GB. This limit is per cluster node and is mutual for all queries running concurrently. If a query uses materialize() and the cache can't hold any more data, the query will abort with an error.

If the amount of concurrency is large, does it mean that it is more error-prone? It will abort with an error if the cache can't hold more data. I want to know how to monitor how many spaces I used of materialize cache? Please help on this question. Thanks.

Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
537 questions
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.