8 Replies Latest reply: Feb 27, 2014 3:27 AM by Joseph Ibrahim RSS

    Performace of Qlikview on a new server

    Braham Edwards

      Due to some new business we expect the data volumes on our Qlikview server to increase significantly. We purchased a new dedicated Qlikview server. The key configurations are 2*6 core Xeon processors (2.5GHZ), 132 GBytes memory and lots of disk space. We have disabled multi-threading.

       

      The performance of Qlikview on this machine is very disapointing. I tested the build of one of our models on a i5 Desktop machine and it was only marginally slower than the new server. When recalculating a graph the machine seems very sluggish. Initial test on the new machione showed it to be only slightly faster than the previous server, which had fewer cores and less memory. Tests on SQL running data extracts from the warehouse shows the new server to be nearly twice as fast as the previous one. SQL hardly uses any CPU, only memory and disk IO.

       

      I know there are techniques for speeding up a Qlikview models, but we are comparing the same model on the two computers.

       

      What I have noticed while running the windows resource monitor is that the CPU usage rarely increases beyond about 70%. When I ask Qlikview to refresh a graph, I click accross to the monitor and watch what is going on. Once the Qlikview model has loaded there is virtually no disk IO. The CPU peaks at about 70% and you wait and wait for the graph to refresh.

       

      I have also monotored the building of a model. The CPU runs at about 40-60% for most of the time. When the model starts to build the sythetic indexes the CPU maxes at 8%. I assume that the 8% is due to one core in the 12 is being fully utilised. Building the sythetic indexes also takes a long time. All the testing I did was when there were no other users on the server.

       

      I would appreciate some input from other who have dealt with this issue. Is there any way to get Qlikview to utilise more of the CPU? I am left with the impression that the models will run much faster if the CPU were better utilised. My thinking may be a bit simplistic, but I would want to see one of the components (CPU, memory, disk IO or NetworkIO) running at 100%. If the CPU is not running at 100%, you should see the disks or memory or Network fully utilised.

       

      I look forward to some input on this matter.

       

      Regards

      Braham