Does anybody use more than 256GB RAM on QV Server?

[#1]

We would like to build a server with as much RAM as possible. Does anybody have first hand experience with 512GB or 1TB RAM server? Can you effectively use all the memory for your data? Are there any bottlenecks, CPU<->Memory, for example?

What are your hardware specs, how many DIMMs, their capacity, frequency?

The idea is to have all data in one app without pre-aggregation. The app is already built and works fine with 20GB QVW on a 128GB machine. I can see that QV engine distributes the load to all processor cores evenly. Number of user is also of no issue there. We were told, that after some RAM amount (and data) the scalability is less than linear due to bottlenecks. But a specific threshold was not specified.

[Troy1]

Hi Hampus

If you go with E5-2600 v3 CPU.

• Do you look for higher base clock speed or higher number of cores to balance performance vs concurrent users.
• DDR4 at highest speed 2133mhz can be configured up to 512gb on this CPU's. Would the performance be better with lower amount of memory or at max 512gb. for example 384gb RAM @ same speed will be better performance compare to 512gb (meaning smaller amount is better for higher performance)
• if you are looking at running 1 big application (20gb x 3time = 60gb in memory) + many small ones ( about 7 to 8 of .2gb to 1 gb in size) with 30 to 50 concurrent users would this above setup work?