Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
When i reload the file qvd CPU Usage attained 99% exactly qvb.exe is attained between 80% and 90%
any idee to solve this issue.
Many thanks for your help.
Hi
I am also facing this problem. In my case, I used to run the report once/Hr. Now I have schedule it as once/day & monitoring is going on.
Br
Anta
A bit more information would help here.
Your hardware environment.
Your OS,
Some relevant characteristics of your QVW and QVDs.
Size stored on HDU
Size in memory when full open and quiescent.
Perhaps some sample script or a sample of the QVW "causing" this.
Just as a first measure, restart all the QlikView services and try again. Kind of like rebooting your PC
qvb is the reload engine on publisher. I am assuming you know what document is reloading during that time? If this is a report that did not peg the server previously, you will want to look at a few things. First, was the qvw modified? If the script gets almost all the way through (check the log), then it is possible that a cross join or multiple fields being joined was accidently created, resulting in an overload on the CPU while it tries to resolve. Another possibility is that the underlying database changed. Maybe a table that previously was not populated, is now and has caused a huge influx of data that the qvw might not be equipped to handle. Are multiple docs reloading at the same time? This could also cause a problem as well.
Hi All,
I have many times come across this issue.It might be any one of the following scenarios.
1. No optimisation is done to the report: Resolution: QVD's can be used.
2. If some reports are reloading and parallely while opening a report which has a table that has huga data it get the CPU Usage to 100. Resolution: End the process from the Task manager
3. If multiple Reloads are occuring: Resolution: Try to schedule it such that it doesnt affect the performance of the system
4. If the performance is always slow and the CPU usage is at a consistent 100% Restart the servers.
5. fIf its fluctuating kindly increase the RAM capacity.
Hope this helps you.