topic find dashboard (QVW) with sync key on server in QlikView

find dashboard (QVW) with sync key on server

Troy1 — Wed, 16 Apr 2014 03:01:02 GMT

Hi Everyone

Is there an app or dashboard that can go and find dashboard (out of at least 50 dashboard) 1 with sync key in data model on the server. is it possible.

i have governance dashboard installed is there something in there that can give me some clues.

Second Question:

Does server release memory after documents are not accessed. It seems our server always hold memory even if there is no active document user.

Re: find dashboard (QVW) with sync key on server

Troy1 — Tue, 22 Apr 2014 14:56:47 GMT

any one with clues.

Re: find dashboard (QVW) with sync key on server

hopkinsc — Tue, 22 Apr 2014 15:05:33 GMT

see this document re: RAM..

http://visualdataexperts.com.harderandharderco.com/ServerSizing/QlikView%20Server%20Memory%20Management%20and%20CPU%20Ut…

I don't think there is an easy way of finding a document with synthetic keys..

you are probably just better off opening each qvw in turn and checking the table viewer. it might be quicker than waiting here for a reply.

Re: find dashboard (QVW) with sync key on server

Troy1 — Tue, 22 Apr 2014 17:31:41 GMT

Thanks for very good article. However it doesn't talk about QlikView distribution service reserving memory for itself in single server environment.

we are facing issues where server over time starts using 54gb of Ram out of 64 total in 90/20 set. It crashes or gives errors when multiple reload jobs starts up and initiate more memory request.