Urgent help on performance issue

[Digvijay_Singh]

Need help from experts to get some pointers in resolving performance issue in big qlikview application(problem is specific to this application when accessed from php front end). Here is the issue details.

1. qvw size  - 1.9 GB ( Used from php based front end, when I open it in server, it works fine.)

2. No of Rows - 29 M

3. Qlikview Server Version - 11.2

4. Server RAM - 96 GB ( Showing 60-70% usage), Available RAM is normally 30 GB

5. CPU Cores - 24 ( The usage shoots up to 90-100% and stays there for more than 30-40 secs after every click)

6. Symptoms observed - When I repeat selections, it looks like its not picking object from cache and recalculates it again. Is that the reason CPU usage shoots up everytime. If Yes? then how to identify if its doing paging every time and cache is not enough or something?

Thanks in advance for any kind of suggestions!!!

Regards,

[Digvijay_Singh]

Tagging experts for help -

pcammaert‌

bill.markham

hic

gwassenaar

Thanks in advance!

[rwunderlich]

What is the php front end you are referring to?  Do you mean the standard full browser interface or are you doing something else?

When you say "when I open it in server, it works fine" do you mean you are using the File, Open in Server menu item from Qlikview Developer?

-Rob

[Digvijay_Singh]

Hi Rob,

Thanks for responding.

Yes, its full browser application and when clicked on app link, it opens with opendoc.htm as below-

http://www.abc.com/QvAJAXZfc/opendoc.htm?document=Client42-29.qvw&ticket=30DE31019D84CE3E10C647F0C80...

On 2nd one, I should have written that when opened from qlikview developer in server machine, it works as normal.

Regards,

[rwunderlich · Accepted solution]

The stats you posted show an atypically large number of tables and objects. I would begin by running Document Analyzer

http://qlikviewcookbook.com/recipes/download-info/document-analyzer/

and see if you can eliminate unnecessary data and find some high-calc or high-memory objects to focus on.

I'm surprised that it doesn't perform poorly in the desktop as well. I have seen some apps with high numbers of objects perform slower in the server than desktop, I'm not sure the cause.

The cache observation is interesting. Are you using any data islands? Lot's of variables with "=" signs?  Does your QV Server have enough RAM?

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

[Digvijay_Singh]

When I make few selections to reduce data set, it works as desired.

With no selections, even clicking in time period list box with 20-30 entries takes more than 30 secs.

When no filter is selected or not enough filters are selected, and when I switch metrics between Sales and Margin(metrics/measures are dynamically applied through island tables), it takes same amount of time(No caching it seems?), that gives me some indication whether its doing paging and result-sets caching is not working.

With 98 GB total RAM and 65-70 GB RAM usage in task monitor, looks like there is enough for cache. Working set limit is set as default(70-90%)

[Digvijay_Singh]

Thanks Rob for sharing the link, will use it as the next step.

We are using data islands heavily and looks like dynamic formation of expressions is not helping Qlik to cache the result set.

The RAM is 98 GB, but it has publisher, web server, and few other stuff as well.