We are facing a severe issue for multiple JOBs refresh whene we do QVD extractions for our Qlikview Reports. As we have mulitple reloads happening in Batches from different System Databases. Hence we have to scheduled our extraction reloads ( QVD Extractions) acrss different databases (Oracle and SQL Server). We have scheduled our reloads as per availability of the system right from midnight. But we cannot schedule all the reloads at once as we are not sourcing from Data Warehouses , instead from different reporting databases available.
Now recently we have started facing challenges where the individual systems are giving late handoff due to late EOD activities completion and we are getting delayed from extraction and many times - OVERLAPPED jobs for extraction . This is most important reason for reloads to be consuming maximum resources ( RAM and Memory ). Also checked resource utilization is optimum , its not bottlenecked.
Would need some experts / legends comments as for two main issues which we are facing:
1) Timely refresh of our JOBS which is scheduled as per timing.
2) How can we streamline our reloads across different DB's which is not available at one time ?