topic Re: Cpu usage is 100% in QlikView

Cpu usage is 100%

Anonymous — Thu, 08 Nov 2012 13:50:21 GMT

Hi , my enviroment is 96 GB , 16 core cpu

and my application is 170 MB , 32 M records with 60 fields using a RAM of around 830 MB

data model is just 2 tables linked with one field and pulling these tables from stored QVD.

when I just do a selection in given list box or chart ...cpu usage is raising to 100% (in fraction of sec coming to 67%) and

in performance tab of task manager all the crore peaks are giving significant peaks at 100%

my question is is it normal to take 100% cpu ? the performance of dashorad is very slow .

what is the solution for this ? I Have already seen the list of best parctices and i'm following those ...

Re: Cpu usage is 100%

Thu, 08 Nov 2012 14:08:06 GMT

Hi,

Probably not enough core.

Is it a x64 bit machine?

Re: Cpu usage is 100%

Anonymous — Thu, 08 Nov 2012 14:11:12 GMT

thanks for the reply .....

mine is 64 bit server with 2 processors..

is it good to have 16 core .. have more or less cores helps ?

and data model has 2 table ....1 table with 50 fields and other tabelas has around 9 fields

Re: Cpu usage is 100%

rajeshvaswani77 — Thu, 08 Nov 2012 14:15:32 GMT

Normally 2% to 4% CPU usage is what I have seen. Are there any other services that you need to bring down? Is it QlikView that is consuming the CPU?

Re: Cpu usage is 100%

Anonymous — Thu, 08 Nov 2012 14:30:50 GMT

it's the server with only qv installed ..i don't see any major softwares running..

when i hit reload ..pu usage jump to 100 % ..when i select any filter it jump 100 % .

what does it indicate ..and performance is very slow .. and my object have calculation time of about 5306 each in a given sheet

Re: Cpu usage is 100%

Thu, 08 Nov 2012 14:37:35 GMT

why not do a screen shot of the task manager in processes tab.

sort the last by memory usage. and add in the virtual memo column also.

the thing is u have very high memory but lower CPU power.

i think there's a matching which says each 2gb of ram for 1 core.

something like that.

Re: Cpu usage is 100%

Thu, 08 Nov 2012 14:44:52 GMT

Interesting comment Nick, would love to see where that came from.

I have 200GB Ram in my server and often get the CPUs flat lining at

100%, my data mdoel is fairly complex and the volumes relatively high

(60m rows, 200 columns wide fact, 32 dimension tables joined in star

schema to that fact).

However, I "only" have 24 cores in that server, your statement above

suggests that I should be upgrading to 100 cores!!

I have to say, global bank or not, the chances of that happening are

less promising than me flying to the moon for lunch tomorrow.

Re: Cpu usage is 100%

Anonymous — Thu, 08 Nov 2012 14:45:33 GMT

i'm sorry to ask you this question how to add virtual memo column ?

Re: Cpu usage is 100%

Thu, 08 Nov 2012 15:01:01 GMT

Nigel, yes, you are right.

i was about to do that when someone told me that, may be it was 4GB?

The point is how does the cpu usage reach 100%? i have always to have memo line flat, but cpu is up n down.

n my data size is 5GB with processing time of 3 hours.

and cpu never reach 100%

i think i have very good scripting skill then.

Re: Cpu usage is 100%

Thu, 08 Nov 2012 15:06:39 GMT

Sri, if you take Nigel's scenario and mine.

the only reason could be in your scripting or expression ?

all the point i made are for reference.

please don't buy new cores. i don't believe in that too. but i have intention to do it so i can load some crazy data mart.

Re: Cpu usage is 100%

Anonymous — Thu, 08 Nov 2012 15:13:46 GMT

here is the scrren shot i couldn't it at 100 because it's changes in fraction of second from 100- 98.

coming to expression there are abit complex with variables ...

but i don't undertsand is

i'm using qvd for puling the data ...

.and my app size is only 170 MB

but my server is big of 96 GB with 16 cpu

which it is consumiing this much CPU

Re: Cpu usage is 100%

Thu, 08 Nov 2012 15:17:17 GMT

Sri

Nick is right, you're problem is the same as mine although my model is

more complex, the issues are the same, QlikView is simply trying to do

too much when calculating. You say your expressions are "a bit complex

with variables" well this is the first place I'd look, try to simplify

your expressions by moving as much of that into the load script as you

can.

Post a sample of one of your complex expressions, just so we have an

idea of what you're doing.

Nigel.

Re: Cpu usage is 100%

Thu, 08 Nov 2012 15:21:02 GMT

also, take a look at this doc, hope it's useful for you.

http://community.qlik.com/message/154717#154717