Discussion Board for collaboration on QlikView Publisher.
Hi all, Hope you're fine.
Currently I meet a lot of problem with my QV server.
I have two server:
01QV: QMS & QDS.
02QV: DSC, QVS & QVWS.
My problem is in the 02QV, the QVS Service saturates my cpu at 100%
(Intel (R) Xeon (R) CPU 3292MHz firstname.lastname@example.orgGHz E5-2643), which it make inreachable my portal.
Do you have any idea what causes this cpu saturation? as i know, the 01QV calculat and refresh the report, so the CPU are more used by the 01QV not the 02QV ?
Are you guys still having this problem?
I am having a lot of trouble with this, since when the server reaches 100% of the CPU usage, none of the users are able to connect to the server and see the documents.
Could you solve this problem?
I think we need more info about what is going on on your server to be able to give any feedback why the QVS is hitting 100% as there can be alot of different reasons.
I'm having this issue as well, and we have traced it to some users having multiple sessions open. They open a document in Access point, then when/if it doesn't respond as soon as they expect it to, they close and reopen the doc, and QlikView isn't releasing their previous sessions. So when the CPU usage spikes to 100%, I can check sessions open and sometimes a single user has had as many as 22 sessions open. The only way we have found to release the sessions so far is to stop and restart services. It seems 'Qlikview Server' and 'Qlikview WebServer' are the ones that make the difference.
One point of interest is that the document most often in question is on a scheduled reload every 3 hours. Also possibly related to this is the fact that one tab in this document often will not load for a particular user, which causes them to try closing and reopening.
I'm interested to hear any suggestions anyone has on how to keep QV from holding on to those sessions which is the root of this issue.
I am so sorry about the late reply. It seems like something that happens every couple of months, at the beginning of the month and keeps happening for about 5 days, then it stops.
Answering your questions:
I don't really know where I can see these logs. Could you give me some directions?
It is a physical machine.
It is something that happens periodically. It keeps happening for about 5 days. Then it stops and nothing happens, but maybe two months later, it starts all over again.
I would recommend that you run a performance monitor and system monitor to find out what is going on.
Could be that the system is reaching it´s capacity regarding virtual memory and therefore runs the CPU up to 100% due to resource issues.