Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I want to conceive a new Qlikview architecture and for that I have to choose specially the right hardware requirements for deploying an QlikView Server.
I would like to have some recommendation or help on the choice of equipement.
For information, all applications are run and used every day.
The scope of application is:
The majority of application offer the possibility to the users to calculate aggregation ( by complex set analysys) and we need to have good performances..
I hope you could help me…
Thanks in advance
This information could be useful for you
Regards!
Thanks for the informations.
May I ask you in the Excel file, how do you calculate the colum "qvw vs qvw in RAM" (cell B6) i don't get it well
Thanks in advance
QVW's are usually compressed when they are stored on disk using a zip-like algorithm. So the file on disk will take up less space there as it does when it is loaded in memory. This is something that can be configured also, so check your settings before you make this calculation.
Regards,
Bas
very helpful guys..thanks
Thanks Gerardo,
This is good information. However I need some help in case of multiple applications & dashboards ( can be considered as that of same complexity ).
In my case I have 2 applications servers with 51 Applications running on them with below mentioned information.
I am expecting 75 more Applications/ Dashboard in this environment and want to estimate the capacity ie if more CPU & RAM are required and how much.
Could you please help me out with the calculations and make me understand too...Many Thanks in advance..!!
Below are the current status of some important KPIs
System name | System Function | System type | CPUs number | Cores number | Memory size (GB) | OS Family | OS Type |
Server 1 | Qlikview Server 1 | PHYSICAL | 2 | 20 | 256 | Windows | WINDOWS SERVER 2012 R2 |
Server 2 | Qlikview Server 2 | PHYSICAL | 1 | 16 | 48 | Windows | WINDOWS SERVER 2012 R2 |
Current APPS in the iViewinsight Prod Environment | 51 | Daily Total ( Max ) | |
KPI | Max / Hr | Average / Hr | |
Concurrent Apps | 12.00 | 4.42 | 12 |
Concurrent Users | 16.00 | 5.50 | 16 |
Max CPU | 26.00 | 4.71 | 26 |
Max RAM (GB) | 250.53 | 241.49 | 251 |
Total Sessions | 75.00 | 28.63 | 687 |
Total Users | 50.00 | 17.54 | 457 |
Max CPU Load observed during month | 10% | on both servers | |
Max CPU Load observed during month | 5% | on both servers | |
Max RAM Utilization Observed during month | 65% - 75% | on both servers | |
Max RAM Utilization Observed during month | 70% | on both servers |