Scheduled Reload 50% slower than manual reload

[#1]

Hello community

Help please.

We have scheduled several reports and dashboards, mostly they run without issue.The bulk of them refresh over night when business is a lot quieter, others several times over a 24 hour span.

One particular QVD building model has become a lot slower over the past month. It has now gone over 65% slower for no apparent reason. When the refresh is undertook manually it is a lot quicker. What is also perplexing is that at the time the model runs (per schedule ), there are no other processes at work.

We do not use incremental reload as this may not update corrections done from the source data.

Any advice would be most welcome.

re

Paw

[jonathandienst]

Are you sure that there is no process (backup, AV scan, DB maintenance tasks ...) that now runs at the same time as the scheduled load that is affecting the rate of data transfer. The manual load is done at another time and is not affected.

[awhitfield]

Also, check that it's not been held up by another reload around the same time

Andy

[#4]

No, no other reload is happening at that time.

& the source data etl is usually completed and ready when this task commences

I have inquired with the rest of business on any other DB processes and or changes may have been implemented in the past month  that could be a factor. Hopefully there will be something that once sorted all will be well.

[Peter_Cammaert]

A reload executed by the Distribution Service uses memory on top of what the QlikView server has allocated for itself. The two services do not share any memory, and the distribution service may slow down to a crawl if there isn't enough RAM available to load all data in memory (paging and stuff)

Did you monitor memory usage at the time of the (slow) reload? Has the amount of processed data grown over the past month? Have you ever tried restarting the QlikView Server service (just that one) just before the reloads are initiated, so that the QlikView Server service releases all allocated memory which the Distribution Service can use for reloading?

Peter