4 Replies Latest reply: Feb 18, 2014 11:10 AM by Juan Gerardo Cabeza Luque RSS

    qvs spend a lot of ram

      Capture.PNG.png

       

      Capture1.PNG.png

       

      Capture2.PNG.png

       

      can someone explain me the problem???

       

      76gb ram with 4 document??

       

      regards

        • Re: qvs spend a lot of ram
          Byron Van Wyk

          Poorly designed data model with a lot of cached selections can be the result i.e. synthetic keys, ambiguous loops. A bad join like a cross join where no records match exponentially increasing the number of records being loaded. Post a screen shot of the table view if you can. Also use the qlikview governance app to read the model and look at the results there

          • Re: qvs spend a lot of ram
            Michael Laenen

            Hi,

            What's the document size?

            Do you use a publisher? If not, keep in mind that reloads do not manage the RAM as the optimized way for the QVS, the part of RAM used by reload is not always dropped and finally accumulated on the QVS.

            If you have lots of aggr, calculted dimension, staight table, tablebox in the layout it consumes also more RAM.

            Michael

            • Re: qvs spend a lot of ram
              Juan Gerardo Cabeza Luque

              Let me answer with another question: What is the problem?

               

              I mean, do you have any problem if your computer uses as much memory as it can? High memory use in QlikView does not necessary implies bad performance, sometime it is due to caching, so it could use free memory to increase performance instead of having bought 76 Gb and using only 25, and not using 51.

               

              Obviously, sometimes this could cause bad performance if a poor design or the server is not well sized. It is your server paging?