Qlik Community

Ask a Question

QlikView Administration

Discussion Board for collaboration on QlikView Management.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
mohamed_ahid
Partner
Partner

how to use CPU Throttle ?

Hi every body ,

on my server i have several warnings about over use of CPU (99%) .

i try to limite the % of cpu used on server to avoid these kind of message .In performance we have CPU Throttle and CPU Affinity .

what is the aim and the difference of using each other ?

how to use  CPU Throttle ti limite the use of CPU to 90 % (0% means no throttling . 100% is throttling ?)

thx

17 Replies
Peter_Cammaert

You can try with the core split, and see if that helps you any further in reducing the load on your system without angering stakeholders too much.

mohamed_ahid
Partner
Partner
Author

how can i do that ?

Peter_Cammaert

Use the CPU Affinity setting.

mohamed_ahid
Partner
Partner
Author

so what i have said juste before is not right . cpu affinity deffine the number of cpu used by the QV server(not publisher) .

otherwise if i choose 50 % of my cpu's in  cpu affinity ,implicitly that means that ths other parts will be user by QV publisher( reload tasks) ?

Peter_Cammaert

Not entirely, there is no implicit "smartness" in the Publisher unfortunately.

To kick the QDS (Distribution service) into the same marching order, you cannot use the QMC because there is no such thing as the nice row of core check boxes just for the Distribution Service (which is a pity)

However (and IMHO this is the real trick) there is a configuration setting called CPUAffinity that only applies to QVB processes. Open C:\ProgramData\QlikTech\DistributionService\Configuration.xml and look for a line that starts with the tag <QVBConfig>. One of the attributes says... CPUAffinity. Set the digits to the inverse of the checkboxes that you marked for the QVS in the Management Console. Restart the QlikViewDistribution Service and...

mohamed_ahid
Partner
Partner
Author

but what hapened if i don't have qlikview publisher ?

Peter_Cammaert

Just the same thing. Not having a Publisher license only means that you don't have a "Management Department" for reload tasks. The main impact of not having a license is in the trigger & distribution feature list, not in the actual reload system. The same QVB process will be started, and it will obtain the QDS configuration which says that some cpu cores can be used for reloads and others should be left alone.

Works like a charm.

View solution in original post

mohamed_ahid
Partner
Partner
Author

thanx a lot Peter .