Blog Post

Azure Data Explorer Blog
2 MIN READ

Query past data with hot windows

vplauzon's avatar
vplauzon
Icon for Microsoft rankMicrosoft
Oct 29, 2021
Here is a situation.  Let's say we cache the last month of data in Azure Data Explorer (ADX).  This is great for our operational queries which are all done within that last month of telemetry:  it li...
Updated Oct 29, 2021
Version 1.0
Pankaj Suri's avatar
Pankaj Suri
Former Employee
Jan 24, 2022

please note, it might need to scale-out the cluster to accommodate hot windows if the cluster is running close to 100% cache capacity. Running cluster above 100% cache capacity means the hot data is spilling over into cold cache and may hurt query performance.