Need More memory, Is there a Maximun amount of memory QV 9.0 will use?

[#1]

We are currently using QV 9.0 SR1, on a Win 2008 R2 Enterprise OS with 64GB of RAM. We are looking to getting something that can use more memory but would like to know if QV will use it. Is there a Maximum amount of Memory QV will use?

Thanks as Always..

Moe.

[#2]

As far as I know, there is no maximum memory limit for QV. QV will take all available memory regardless of how much you have. It depends on the size of your data, number of users, server status,etc. So it is the best practice to test with applications like document analyzer/optimizer on Access Point to estimate how much RAM and Processing power you will need.

Ryan

[#3]

Moe,

Are you running 32 bit or 64 bit system?If 64 bit,you can increase the memory. Memory usage of QV depends on the amount of data being used in the report and other factors like joins,editable fields etc.

Thanks,

Santhosh.

[#4]

64 BIT, So basically it will take as much as it needs to do the job and there is no upper limit?

Good to here.

[Anonymous]

Correct. Your system should be able to use up to 2 TB RAM, and QV will be glad to use as much as it wants. In theory, 64-bit allows to address up to 16 exabytes memory, but it's maybe more than all PCs in the world have together 🙂

[#6]

So we have our server with 256GB Ram... 4 x 6Core Proccessors.. and QV still freezes for 5 Min when chewing on a few million rows..

I think we don't need a bigger boat but a better solution..

[StefanBackstrand]

QVS does not use all available memory, in reality. Memory consumption is governed by the QVS Working set limit settings. They default as Low/High/Cache=70/90/10, and is a pretty descent value for most configurations - but not for larger ones.

The values are % and represents limits to where QVS can "go" in memory. 70%/90% of 256GB RAM is ~180GB/~230GB. That means that QVS cannot use more 180, and that it will definately never use more than 230 (note that this is a *very* cut-down explanation of the memory management in QVS). Windows will very seldom need more than, at most, 2GB for it's own processes, and since it is a dedicated QVS machine, there are probably no other major processes that need that, otherwise unused, memory.

You can up the ws limits to cover more memory on a system like that.

If you are having trouble with a tiny data set of a couple of million rows (in a Qlikview world that is truly tiny) on a 256 GB system, then the problem is likely in your data model or anywhere else in the system - not in Qlikview's ability to use memory.