How to interpret automatic aggregation training graph

Hi , Kandarp

According to your description, you want to to know the "automatic aggregation training graph".

The Query performance impact lift chart provides estimated report query run times as a function of the percentage of queries that will use cached aggregations.

The chart can help you determine if adjusting the percentage of queries that use the in-memory aggregations cache can potentially further improve query response.

Threshold appears as a marker line on the lift chart and indicates the target query response time for your reports. You can then fine-tune the percentage of queries that will use the aggregations cache to determine a new query percentage that meets the desired threshold.

DirectQuery : An estimated duration in seconds for a report query sent to and returned from the data source by using DirectQuery. Queries that can't be answered by the in-memory aggregations cache will typically be within this estimate.

Current query percentage : An estimated duration in seconds for report queries answered from the in-memory aggregations cache, based on the percentage setting for the most recent training/refresh operation.

New query percentage :An estimated duration in seconds for report queries answered from the in-memory aggregations cache for the newly selected percentage. As the percentage slider is changed, this metric reflects the potential change.

As I understand it, the main function of this icon is to design a threshold for your expected query time, and then adjust the different percentages of queries to get the fastest new query percentage.

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly