Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

CPU USAGE FULL 100%

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.

4 Replies
Not applicable

CPU USAGE FULL 100%

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

Not applicable

CPU USAGE FULL 100%

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.

aaroncouran
Contributor III

CPU USAGE FULL 100%

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.

subin6600
Contributor III

CPU USAGE FULL 100%

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.

Community Browser