Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
We have Dedicated Qlikview Server 2008 with publisher.
we are building new server. I want to estimate best possible hardware configuration. Below is my calculation. Please indicate if it is correct and what i should use.
RAM
1gb OS RAM usage
60gb QVW (6gb X 10 time in RAM)
6gb 30 users (20 concurrent users) 10 % rule
-----------------------------------------------------------------------
67gb Total RAM required.
CPU
20 simultaneous
X 2 (2 query per minute)
X 120 Double the QVW in RAM
-----------------
4800 Total CPU Seconds
how do you choose what kind of CPU will be required.
Anything else that should be considered?
Your estimate the of the QVW size in RAM seems very high to me. The best method is to actually open the QVW and see how much the RAM jumps up and use that number. Your per concurrent users number is conservative. Typically a range of 8-10% is used.
As to the the OS and the QV Server this will be so much smaller than the RAM used the by QVWs that I wouldn't worry about it. Just round up from what you estimate by the QVWs.
The type of license will make not impact on the resource requirements.
Finally you can get a much more accurate understanding of the resources requirements by looking at your current environment. I would recommend download the Ops Monitor or Governance Dashboard. They will pull all your log files together and show you your real world usage vs uses these estimates.
Qliktech has produced this Server Load Simulator to estimate server sizes. It allows you to play with the variables and see estimates.
Thanks for all the answers.
Hi Guys
Any update on my query. My main question is how do you determine CPU requirements and how many CPU's and core you will need.
thanks
I would recommend using the Ops Monitor or the Governance Dashboard. If you do not have usage information available then I would recommend you engage a QlikView consultant or your QlikView Sales team.
Hi Josh
This is for new server.
If we have 40 concurrent users. How much CPU power would you recommend. I understand that it all depends on usage and what QVW those users are accessing. However lets assume we have 6gb worth of QVW and all of them are being access by 40 concurrent users. I am able to determine RAM size however not sure how to go about determining # of CPU & Cores required. What are basic formula.
I would recommend you engage a QlikView consultant or get in touch with your sales team who will be able to assist.