Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
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. . . .
Thanks in advance.
Note: QV Version- 11.2 SR3
Thanks & Regards,
Prasad D. Dumbre
Hi Prasad,
I would check the reload log of both occasions and compare them. Are the tables much larger?
Have you measured the bandwidth?
Output on the database side?
Have you recently upgraded any components?
Regards,
Erik
This could be related to anything from Server load to bandwidth usage.
Are your databases having extremely large queries run during refresh time - ask DBA
Is your bandwidth being used elsewhere - Ask Infrastructure
Is the CPU being over burdened on the QV Server Governance Dashboard- Check
Is the QV Server low on RAM - Governance dashboard
Is it reloading during peak usage times - Governance Dashboard
etc