2 Replies Latest reply: Jul 23, 2017 5:46 PM by Rob Wunderlich RSS

    sizing and machine estimation

    shay raber

      Hi,

       

      Recently we are suffering from a performance issues.

      We added recently a large document and I wish to perform estimation to our hosting machine.

      I have an Excel spread sheet which calculates the machine's requirements (RAM, cores and CPU) and it depends mainly on documents, their footprint, and estimation of concurrent users.

      Few questions:

      1. 1. We have few document that only u (BI and IT team) use but they appear at the access point –should they also be considered (they're small and rarely in use)?
      2. 2. Concurrent users – can I 'trust' the No. in the governance dashboard? Seems a bit low…
      3. 3. When calculating document footprint – should I open the document locally and view how high the RAM is in use until the document opens? Or how high the RAM is while navigating inside the model?

      Please advice

        • Re: sizing and machine estimation
          Or Shoham

          This is a little tricky..

          1) This depends on your server and document settings. If you do not keep these documents in memory (no pre-load, reasonably short document timeouts) - I would not consider these in the calculations, or would account for one of these to be loaded during any specific time period if I wanted to be conservative.

          2) As far as I know, the number in the governance dashboard is safe to use. You can also cross-check this with live values which you can get from the QMC at any time point under Status / QVS Statistics.

          3) The rule of thumb I am familiar with for calculating RAM footprint is the full size of the document as loaded (or as saved to disk with no compression), and an additional 10% per user (e.g. 200% of the base size if 10 users are active at once). If you allow more than one copy of the document in memory (another QVS setting), you may have to account for the possibility of multiple copies at once depending on your reload frequency and timing.

           

          If you are running your QV reloads on this machine, you should account for those as well - each one will eat up varying degrees of RAM and CPU during the reload cycle.

           

          Keep in mind that this applies primarily to RAM requirements - CPU requirements are going to have a lot to do with QVW reloads and specific CPU load of individual QV objects. I/O requirements should also be considered if you frequently reload your documents, as the need to regularly save QVWs or QVDs to disk and read from these files can result in slow performance, particularly when opening a document that is not pre-loaded or that has just been re-loaded.

          • Re: sizing and machine estimation
            Rob Wunderlich

            To calculate RAM footprint for a document, I (as do thousands of others ) rely on

            Qlikview Cookbook: QV Document Analyzer http://qlikviewcookbook.com/recipes/download-info/document-analyzer/

             

            You can use the

            Qlikview Cookbook: DA Compare Tool http://qlikviewcookbook.com/recipes/download-info/da-compare-tool/

            to aggregate RAM requirements for multiple documents.  I note there is a possible bug in the multi-user calculation in the Server Sizing sheet.  But you can manually calculate using the "Per User Memory" figure on the DA Memory sheet.

             

            -Rob

            http://masterssummit.com

            http://qlikviewcookbook.com