26 Nov 2020 06:58 AM - last edited on 22 Apr 2021 07:38 AM by MaciejNeumann
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/4th 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.
Solved! Go to 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.
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.