Hi,
I don know is this right place to ask this question. Every month I have scheduled reports, which are working for previous month, and approximately have the same number of data every month. The problem is in report time execution.
In the last year by July every month the time was the same, and it had 6 hours for all reports. But from July it was prolonged for 2 more hours ,and it had 8 hours for all reports, and so on every month to the end of year. In 2015, from January the time was reduced, and again it lasted about 6 hours till October. Now in november again needs 8 hours.
What can be cause of this, and how to handle it.
Thnkas
The amount of data the report consumes might vary like that. For example, something that aggregated year-to-date and there was a significant volume added at those points in time.