Qlik Community
Collaborate with over 60,000 Qlik technologists and members around the world to get answers to your questions, and maximize success.
Join Us1. Find an example where a document is being load balanced (search for "LoadBalancing - doc: UserDocuments\SOMEFILE.qvw" in the Web Server logs)
2. Find the corresponding entry in the Utilization logs (search for SOMEFILE.qvw at the timestamp seen in the Webserver logs.
3. Using the above, get the CPU and VMFree information to see what decision is being made.
Example: "Loaded Document"
In the below example we can see that SOME-SERVER-1 already has SOMEDOC.QVW loaded (loaded: True) so it will be loaded there due to the load balancing rule. This server does also have more VM free and CPU free as well, so hypothetically if the document were already loaded on both SOME-SERVER-1 and also SOME-SERVER-2 then it would load balance to SOME-SERVER-1 in that case.
Webserver Logs:
20180327T153123.150+0300 Information LoadBalancing - doc: UserDocuments\SOMEDOC.QVW 20180327T153123.150+0300 Information Sending to 'SOME-SERVER-1:4747': <Global method="GetUtilizationData"></Global> 20180327T153123.150+0300 Information Sending to 'SOME-SERVER-2:4747': <Global method="GetUtilizationData"></Global> 20180327T153123.150+0300 Information Received from 'SOME-SERVER-1:4747': <Global><UtilizationData>...</UtilizationData></Global> 20180327T153123.150+0300 Information Received from 'SOME-SERVER-2:4747': <Global><UtilizationData>...</UtilizationData></Global> 20180327T153123.197+0300 Information Qvs name: SOME-SERVER-1 loaded: True VMFree: 37000.568714 20180327T153123.244+0300 Information Qvs name: SOME-SERVER-2 loaded: False VMFree: 33000.987663 20180327T153123.244+0300 Information LoadBalancing - selected Qvs: SOME-SERVER-1
Utilization Logs:
Datetime ServerName DocumentName GBytesOfRamConfigured NumberOfCores RecentCpuPercent RecentRamOverload 3/27/2018 3:31:23 PM SOME-SERVER-1 UserDocuments\SOMEDOC.QVW 512.000000000 20 0 0 3/27/2018 3:31:23 PM SOME-SERVER-2 UserDocuments\SOMEDOC.QVW 512.000000000 20 2 0
20180411T074726.977+0300 Information Sending to 'SOME-SERVER-1:4747': <Global method="GetUtilizationData"></Global> 20180411T074726.977+0300 Information Sending to 'SOME-SERVER-2:4747': <Global method="GetUtilizationData"></Global> 20180411T074726.977+0300 Information Sending to 'SOME-SERVER-3:4747': <Global method="GetUtilizationData"></Global> 20180411T074726.977+0300 Information Sending to 'SOME-SERVER-4:4747': <Global method="GetUtilizationData"></Global> 20180411T074726.977+0300 Information Sending to 'SOME-SERVER-5:4747': <Global method="GetUtilizationData"></Global> 20180411T074726.977+0300 Information Sending to 'SOME-SERVER-6:4747': <Global method="GetUtilizationData"></Global> 20180411T074726.977+0300 Information Received from 'SOME-SERVER-5:4747': <Global><UtilizationData> <GBytesOfRamConfigured>537.324842834</GBytesOfRamConfigured> <NumberOfCores>24</NumberOfCores> <RecentCpuPercent>0</RecentCpuPercent> <RecentRamOverload>0</RecentRamOverload> <OffDuty>false</OffDuty> <Unlicensed>false</Unlicensed> <Free></Free> <DocIsLoaded>false</DocIsLoaded> </UtilizationData></Global> 20180411T074726.977+0300 Information Received from 'SOME-SERVER-6:4747': <Global><UtilizationData> <GBytesOfRamConfigured>537.324842834</GBytesOfRamConfigured> <NumberOfCores>24</NumberOfCores> <RecentCpuPercent>0</RecentCpuPercent> <RecentRamOverload>20</RecentRamOverload> <OffDuty>false</OffDuty> <Unlicensed>false</Unlicensed> <Free></Free> <DocIsLoaded>false</DocIsLoaded> </UtilizationData></Global> 20180411T074726.977+0300 Information Received from 'SOME-SERVER-1:4747': <Global><UtilizationData> <GBytesOfRamConfigured>537.41841774</GBytesOfRamConfigured> <NumberOfCores>24</NumberOfCores> <RecentCpuPercent>6</RecentCpuPercent> <RecentRamOverload>0</RecentRamOverload> <OffDuty>false</OffDuty> <Unlicensed>false</Unlicensed> <Free></Free> <DocIsLoaded>false</DocIsLoaded> </UtilizationData></Global> 20180411T074726.977+0300 Information Received from 'SOME-SERVER-4:4747': <Global><UtilizationData> <GBytesOfRamConfigured>537.418412399</GBytesOfRamConfigured> <NumberOfCores>24</NumberOfCores> <RecentCpuPercent>0</RecentCpuPercent> <RecentRamOverload>0</RecentRamOverload> <OffDuty>false</OffDuty> <Unlicensed>false</Unlicensed> <Free></Free> <DocIsLoaded>false</DocIsLoaded> </UtilizationData></Global> 20180411T074726.977+0300 Information Received from 'SOME-SERVER-2:4747': <Global><UtilizationData> <GBytesOfRamConfigured>537.41842041</GBytesOfRamConfigured> <NumberOfCores>24</NumberOfCores> <RecentCpuPercent>0</RecentCpuPercent> <RecentRamOverload>0</RecentRamOverload> <OffDuty>false</OffDuty> <Unlicensed>false</Unlicensed> <Free></Free> <DocIsLoaded>false</DocIsLoaded> </UtilizationData></Global> 20180411T074726.977+0300 Information Received from 'SOME-SERVER-3:4747': <Global><UtilizationData> <GBytesOfRamConfigured>537.418497848</GBytesOfRamConfigured> <NumberOfCores>24</NumberOfCores> <RecentCpuPercent>0</RecentCpuPercent> <RecentRamOverload>0</RecentRamOverload> <OffDuty>false</OffDuty> <Unlicensed>false</Unlicensed> <Free></Free> <DocIsLoaded>false</DocIsLoaded> </UtilizationData></Global> 20180411T074726.977+0300 Information Create client: Mode=Authenticate, Host=SOME-SERVER-3:4747, ClientIP=10.20.30.40, MachineId=12345678-abcd-efgh-1423-987654321abc, Slot=
Datetime ServerName DocumentName GBytesOfRamConfigured NumberOfCores RecentCpuPercent RecentRamOverload 4/11/2018 7:47:26 AM SOME-SERVER-5 UserDocuments\SOMEDOC.QVW 537.324842834 24 0 0 4/11/2018 7:47:26 AM SOME-SERVER-6 UserDocuments\SOMEDOC.QVW 537.324842834 24 0 20 4/11/2018 7:47:26 AM SOME-SERVER-1 UserDocuments\SOMEDOC.QVW 537.41841774 24 6 0 4/11/2018 7:47:26 AM SOME-SERVER-4 UserDocuments\SOMEDOC.QVW 537.418412399 24 0 0 4/11/2018 7:47:26 AM SOME-SERVER-2 UserDocuments\SOMEDOC.QVW 537.41842041 24 0 0 4/11/2018 7:47:26 AM SOME-SERVER-3 UserDocuments\SOMEDOC.QVW 537.418497848 24 0 0
Collaborate with over 60,000 Qlik technologists and members around the world to get answers to your questions, and maximize success.
Join UsSearch Qlik's Support Knowledge database or request assisted support for highly complex issues.
Submit a caseExperiencing a serious issue, please contact us by phone. For Data Integration related issues please refer to your onboarding documentation for current phone number.
Call Us