User session query - Data limits

[Ahmed_mohamed-s]

Hi All,

Can you please check below message while query user sessions and how can i fix it?

To improve performance, your query was applied to a subset of 1/4^th of the data. With your current average load, the maximum timeframe of the exact data is 17 h 7 min. The results have been extrapolated because the timeframe was bigger than this. To avoid it, you can reduce the timeframe to less than 17 h 7 min.

Thanks,

Ahmed

[ChadTurner · Accepted solution]

It appears that you hit a data limit on the USQL. much like you might get a 'Too much data to display' message on tile for CPU usage meanwhile your environment might have 10k hosts. Per the message you received, id trim down your time to 17 hours or less.

[Ahmed_mohamed-s]

Hi Chad,

So your recommendation is to increase the servers CPU resources.

How to measure and assess the required resources, cause i have applied the recommendations in the dynatrace docmentations.

Thanks,
Ahmed