4 Replies Latest reply: Jan 17, 2012 12:14 AM by Subin Thomas RSS

    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.

        • 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

          • CPU USAGE FULL 100%
            David Braune

            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.

              • CPU USAGE FULL 100%
                Aaron Couron

                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.

              • CPU USAGE FULL 100%
                Subin Thomas

                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.