Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
how can i do that ?
Use the CPU Affinity setting.
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) ?
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...
but what hapened if i don't have qlikview publisher ?
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.
thanx a lot Peter .