Seven Days Performance Reporting Manager Reports Generation Takes a Lot of Time for 10 Data Properties (6611541)

When the number of agents being monitored and size of performance data is high, say over 100, generation of reports for the data of the last seven days takes very long. Seven days is the time limit from the current date till which the historical data at the smallest detail level is retained in the database. The smallest detail level is hourly. So, this report requires the database to retrieve the largest amount of data. The data size increases when the number of data properties requested for are more. Eight days also puts the same amount of stress on the database, since it retrieves data for seven days.

Beyond eight days, the historical data is retained at daily, weekly, and monthly intervals. Hence report generation for time ranges of over eight days is faster.

Workaround: When the number of agents is high, reduce the time limit for hourly data from seven days to five days .