topic Re: Memory Utilization More than Usage Memory in QlikView

Memory Utilization More than Usage Memory

khasimvali85 — Wed, 11 Jun 2014 04:28:15 GMT

Hi,

Can Anybody Explain Memory Utilization in QV Server, Memory is Reached Maximum Size.

How can we Reasolve This?

Thanks

Khasim.

Re: Memory Utilization More than Usage Memory

ashfaq_haseeb — Wed, 11 Jun 2014 05:20:53 GMT

Khasim It happens usually.

I must say it depend on the type of calculation you have in your application.

Nevertheless try by restarting QlikViewservices and will kill any hanged process and release you memory.

hope it helped.

Regards

ASHFAQ

Re: Memory Utilization More than Usage Memory

sarvjeet — Wed, 11 Jun 2014 05:38:29 GMT

It could be due to heavy operation by QMC reload tasks. Check if some big QVD is getting loaded in ETL part

To identify the Dashboard memory usage .Try to create Memory usage dumps for dashboard. That will help in identifying the memory issues in dashboard .

Re: Memory Utilization More than Usage Memory

khasimvali85 — Thu, 12 Jun 2014 06:12:15 GMT

Hi Sarvjeet Singh,

Give me Detailed Explanation of Memory Utilisation of Servers

Thanks

Khasim.

Re: Re: Memory Utilization More than Usage Memory

ashfaq_haseeb — Thu, 12 Jun 2014 06:15:44 GMT

Hi,,

Go through the attache excel sheet for memory calculation.

If you want to see how and where memory utilized more try governance dashboard.

Hope it helped.

Regards

ASHFAQ

Re: Re: Memory Utilization More than Usage Memory

khasimvali85 — Thu, 12 Jun 2014 06:20:24 GMT

Hi,

Give Your Mobile No i Call you at lunch time

Thanks

Khasim.

Re: Re: Memory Utilization More than Usage Memory

ashfaq_haseeb — Thu, 12 Jun 2014 06:21:08 GMT

ashfaqhaseeb@gmail.com

Re: Memory Utilization More than Usage Memory

Peter_Cammaert — Thu, 12 Jun 2014 06:28:09 GMT

Add more RAM.

QVS has its own memory manager. QVS will collect and keep every bit of memory that it ever had a need for. The VM size for this process will only grow, except if you restart the service. Only then, memory will be released. Don't worry, this is a good thing.

A QVS size that is often near the absolute max. is indicative of RAM under pressure. Imagine that a big reload job tries to start? it won't get any memory from QVS, and there won't be any spare left in the system.

Ashfaq's spreadsheet can help you in determining the optimal amount of RAM. Note you should add a safe amount for reloads if this platform also runs the QlikView Distribution Service. Add the memory size of the largest reload job (single task chain), or of the largest set of reload jobs that run in parallel.

Re: Memory Utilization More than Usage Memory

khasimvali85 — Thu, 12 Jun 2014 06:43:13 GMT

Hi,

Thanks for giving Suggession, but This Issue has been coming for last 4 days.

Re: Memory Utilization More than Usage Memory

Peter_Cammaert — Thu, 12 Jun 2014 07:02:37 GMT

In trying to find the root cause: what has changed when these memory spikes first occurred? Did you publish a heavy document? Did you add a lot of new QlikView users?

Re: Memory Utilization More than Usage Memory

khasimvali85 — Thu, 12 Jun 2014 08:44:13 GMT

Hi,

for last 4 day i am doing Schedules So the cause was started last 4 days

Re: Memory Utilization More than Usage Memory

Peter_Cammaert — Thu, 12 Jun 2014 12:34:57 GMT

These problems started with the first reload task?

What calculation did you use to size your QVS machine?

Re: Memory Utilization More than Usage Memory

khasimvali85 — Thu, 12 Jun 2014 14:51:32 GMT

Hi,

no i was run the batch files only after that Auto mails also will run

Re: Memory Utilization More than Usage Memory

khasimvali85 — Thu, 12 Jun 2014 14:55:22 GMT

Hi,

before i was run the batch file reload all QVW files after i run batch file, maybe this is the one of the reason right?

Re: Memory Utilization More than Usage Memory

sarvjeet — Thu, 26 Jun 2014 05:00:51 GMT

Can u please elaborate? Is it touching working set high or Low.

If memory is staying at working set Low it is not bad thing to have . that means your cache is is memory.

QVS will keep on clearing cache whenever it require more space in memory. Removal process of cache ingredients is based on internal qlik architecture. I think it is based on how frequently data is used, how complex the data calculation is.

- Sarvjeet

Re: Memory Utilization More than Usage Memory

khasimvali85 — Thu, 26 Jun 2014 11:12:00 GMT

Hi,

Memory Utilization touching High i.e nearly 99%