Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

4GB of RAM

Hi,

Do you have any idea how much data can a server with 4GB RAM handle? just an estimate to give myself an idea..

Thanks!!

7 Replies
Not applicable

Re: 4GB of RAM

afaik our sandbox-qv-server has 128 gb ram.... and its working relative slowly

SunilChauhan
Not applicable

4GB of RAM

qliktech  recommend 4GB for qlikview desktop .then i belive for server 4GB is nothing for server

Not applicable

4GB of RAM

dear sunil,

do u have a http-link , that show these published  recomments  by Qliktech?

greetings

daniel

SunilChauhan
Not applicable

4GB of RAM

i have not the link this time but i havee read somewhere

minimum requirement for qlikview desktop is 1 GB and 4GB is recommened for running smoothly.

or if i am wrong then please correct me.

Not applicable

4GB of RAM

dear sunil.

i tried to open some of my qv-analysis via qv-accesspoint on the PC of our apprentice. This pc has only 1GB Ram. often the charts are canceld during opening.

greetings

daniel

Not applicable

4GB of RAM

Open up your biggest application in the QV desktop client, go to task manager and check how much ram it is using.  Now multiply that by how your total CAL's.  This is a rough guide as to the absolute maximum RAM you will need.  You can then add 10-20% for growth of your userbase or application or deduct 10-20% for budget constraints.

As a real world example, i have a 5 million row document across a star schema of 12 tables that consumes 400mb RAM

Your server could handle 30 instances of that document easily with overhead left for OS and a couple of reload engines.

Bear in mind this is for an access point distribution system, if all your users are opening via the qv client then it's the ram on their local machine that counts.

More RAM does not increase the speed of reloads greatly once you are above 4gb, generally that is drive speed, cpu architecture and software engine.  My dev machine is an 8gb i5-650 and it reloads with qv desktop 2-3 times quicker than our production server which is a 4x6core opteron with 128gb running qv server 10 sr2 however when our server was running qv9 sr5, both reloaded the same document in the same time.

kamalqlik
Not applicable

Re: 4GB of RAM

It will largely depend on your application as well as the hardware and software. Running pivot tables with millions of rows and calculated dimensions may cause crashes in the application, while with few hundreds it may work just a bit slower than usual. High timeouts will affect as well. Several reloads at the same time, browser versions, number of licenses, OS updates/patches...

Some logs from the server in addition to the events recorded in the Windows log would be useful to trace the issue and give you some tips on how to improve that......

For the better understanding I am attaching the PDF for getting how much the Ram is used............

Hope this will help you