Nuno hello,
the best way to dig into this is through azure cost analysis. go to the cost management + billing service in the portal, select your subscription, and then open 'cost analysis'.
here, you can filter the view to your specific data explorer cluster. use the 'resource' filter and find your adx cluster. then, look at the costs grouped by 'meter'. this will break down the charges into line items like 'hot zrs read ops', 'cold lrs write ops', etc. this confirms what you're being charged for.
to understand what is generating these operations, you need to look at the azure data explorer diagnostics. you should have diagnostic settings enabled to send logs to a log analytics workspace.
once the logs are in log analytics, you can run kusto queries against the 'AzureDiagnostics' table to see the operations. you can filter by your cluster name and look for logs related to data ingestion, queries, and exports. a high volume of queries on older data would explain cold read operations, while constant data ingestion would explain hot write operations.
the presence of both just means your cluster is interacting with data in both the hot cache and the long term storage archive, which is normal for an active cluster.
regards,
Alex
and "yes" if you would follow me at Q&A - personaly thx.
P.S. If my answer help to you, please Accept my answer