We have one .QVD Generator runs during night and it fetches data from SAP-R3. Many time we observed drastic increase in its avg reload time. Its normal reload time is around 2 hour 40 Mins. But sometimes it takes upto 6 hours.
Tables which shows drastic increase in reload time are:
1) IBINVALUES (MinTime: 30 Min, Max Time: 2 Hour)
2) JEST (MinTime: 20 Min, Max Time: 1 Hour)
3) VBFA (Min Time: 30 Min, Max Time: 1 Hour)
Doing incremental on them is option, But how can we find that why only on some days it takes more times while on other it takes normal time.
Any idea / suggestions in finding the root cause are appreciated. . . .