What kind of server specifications should have QV 11?

[olramirez]

Hello,

i have QV 11 in server: Processor Intel Xeon CPU L3406 2.27GHz, RAM 8GB, OS 64Bits. But it is very slow to see dashboard and execute ETLs.

Could you recommend some specifications?

Thanks

[ashfaq_haseeb]

Hi,

Check if this helps

Hardware recommendation

Regards

ASHFAQ

[olramirez]

Thanks Ashfaq,

but i don't understand very well the calculations.

I have 10 users, but when i run the ETL, it is very slow (30 minuts) and just have 160.000 registers.  The QV Application just have 4 sheets and nothing special calculations.

[ashfaq_haseeb]

Hi,

Can you tell me what is the amount of ram it does consume when application is loaded first time?

you make to make sure that with every new users accessing the same application + 20 more ram is required.

You can even look at tweaking scripts

Regards

ASHFAQ

[barnaby]

G'day Olga,

RAM is the key resource. We have around 10 users logged in at any one time and will have up to 15 documents in memory. The main document is around 300M. So we are running quite well on 12G RAM on the server.

Regards,

Barnaby.

[olramirez]

Ashfaq,

the RAM is 6.4GB when i load the application.

Thanks.

[olramirez]

Barnaby,

thanks, i have an idea with this.  I think my problem is the RAM because i just have 8GB, and to load the application take 6.4GB.

The main document is around 680MB.

Regards,

Olga

[ashfaq_haseeb · Accepted solution]

Hi,

Then consider upgrading ram.

Regards

ASHFAQ

[Colin-Albert]

Have a look at your data model to see if you can optimise the application to reduce the memory footprint - For example, can you replace datetime fields with separate date & time fields. Can you reduce the number of unique values in some fields.

Also nowadays 8Gb is a very small amount of ram in a server - memory is cheap and a very effective upgrade.