Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Cpu usage is 100%

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 ...

12 Replies
Anonymous
Not applicable
Author

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

Not applicable
Author

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.

Not applicable
Author

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

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