8 Replies Latest reply: Jan 26, 2011 9:51 AM by todwith1d RSS

    Deallocate memory from server

       

      Is it possible that the memory used up by a previously opened document is released when no user is accessing that document? I see that the qvs.exe continues to hog up the memory even when no user is currently accessing that document. I know restarting the QlickView server service would resolve that, but it would not be a practical solution.

       

      Thanks,

      Dinesh.



        • Deallocate memory from server
          Miguel Angel Baeyens de Arce

          Hello Dinesh,

          There are several timeouts to control that. You have two timeouts in the document itself, in the Settings menu, Document Properties, Server tab.

          The other are in your Enterprise Management Console, browsing to "System", "Setup", QlikView Servers (expand to select your server), and on the right pane "Documents" and "Performance".

          This will allow QlikView server to terminate inactive sessions and release cpu and memory.

          Hope this helps.

            • Deallocate memory from server

              Thank you for your response. All these settings which you mentioned, terminates a user session, but does not mean that it will de-allocate the memory. Are you sure that the memory de-allocation will happen after the session time-out? I do not see any qlickview process in the task manager for the specific user, & hence my question...What is a user session in the physical sense?

              Thanks,

              Dinesh.

                • Deallocate memory from server
                  Rob Wunderlich

                  The document memory should be released after all users sessions have ended and "Document TImeout" setting has expired.

                  There is not a seperate task for each user session. User sessions are maintained and tracked within the qvs.exe task.

                  -Rob

                    • Deallocate memory from server

                      Guys,

                      We are on version 9.0.7646.9 and I have checked the settings you mentioned above.

                      We have 48 GB of memory and around 37 GB are used at peak on a typical day.

                      Each morning (before reloads and users come in), the memory used is still up in the 33 to 35 GB range.

                      All the reloads are dropping tables, the timeout is set to 30 minutes and none of the documents have settings that would cause them to stay in memory.

                      what else can I check ? Is there any way to determine what documents are in memory at any given time?

                      It just seems like memory should be dropping WAY below that number.

                      Thanks, TD

                       

                        • Deallocate memory from server
                          Rob Wunderlich

                           


                          todwith1d wrote:Is there any way to determine what documents are in memory at any given time?


                          You can see what documents and user sessions are active in the QEMC "QVS Statistics".

                          When you come in in the morning and memory is high, does QVS Statistics show any documents in memory?

                          -Rob

                            • Deallocate memory from server

                              I will look at that in the AM.

                              I'm beginning to wonder if it's disembodied data :-) or remnants from a failed scripts. Is that even possible ?

                              This machine sees a lot of development and, I suspect, script failures after some data has been loaded into memory. Is that data trashed after the document is closed for the document expiration time ?

                              Thanks for any thoughts.

                                • Deallocate memory from server
                                  Rob Wunderlich

                                   


                                  todwith1d wrote:I'm beginning to wonder if it's disembodied data :-) or remnants from a failed scripts. Is that even possible ?


                                  Your initial post said the memory was being accumulated in the qvs.exe task. Scheduled reloads (scripts) run in spawned tasks qvb.exe, so that memory will be released when the reload ends. Developer work on this machine would run in a qv.exe task which would be released when the QV Developer session is closed. So, no, script executions should have no effect on qvs.exe memory. qvs.exe is only used to serve up documents to users.

                                  -Rob