Task performance summary

In 11.20 SR 7 a new feature has been introduced "Task performance summary".   This feature is also applicable to QlikView 12.XX versions as well.  NOTE:  Does not work in Qlikview 12.0 track.

This article provides an overview on how to set up and how to troubleshoot this problem and is also provided in the QlikView Help

 

From Release Notes 11.20 SR 7

1.3.3 Task performance summary

New task performance summary added that will provide information about the amount of RAM 

used, CPU and QVB elapsed time. 

Information is to be to be used for planning and troubleshooting purposes. 

RAM information

Peak RAM: 

 - The highest amount of consumed RAM during the task run, divided into physical and virtual. 

Total peak RAM:

 - The highest amount of consumed RAM during the task run for all processes combined on the machine, divided into physical and virtual.

Average RAM

 - The average value of RAM used for the task, divided into physical and virtual.

 

CPU information

QVB peak CPU:

 - The highest amount of consumed CPU during the task run used by the task process (QVB).

Total peak CPU:

 - The highest amount of consumed CPU ran during the task for all processes on the machine. 

Average CPU:

 - The average CPU usage for the task, shown as a percentage. 

Elapsed time:

 - Log the elapsed time run for the QVB.

 

Setting up:

The task performance summary can be activated by setting the EnableQVBProcessSummary to 1 in the QVB Settings.ini file. 

Default location of the QVB Settings.ini file:

C:\Windows\system32\config\systemprofile\AppData\Roaming\QlikTech\QlikViewBatch

Note: The last row in the ini file needs to be blank. 

WARNING: Always backup your INI files before editing them!  Do not make changes to any INI files without guidance from Qlik.

Detailed information on how to setup:

C:\Windows\system32\config\systemprofile\AppData\Roaming\QlikTech\QlikViewBatch\Settings.ini

 

Settings.ini:"

[Settings 7]

InterfaceLanguage=English

InstalledLIBID110={4D121C39-415E-11D1-934D-0040333C91CC}

 

"
 

Note: The last row in the ini file needs to be blank. 

After enabling this and restart of the QlikView Distribution Service in the Task Log a new line will be written.

Name: qvb.exe, PID: 1360, Peak CPU: 50,0%, Peak Physical RAM: 26.00 Mb, Peak Virtual RAM: 21.69 Mb, Average CPU: 1,0%, Average Physical RAM: 24.47 Mb, Average Virtual RAM: 20.37 Mb, Peak Total CPU: 58,3%, Peak Total Physical RAM: 6143.49 Mb, Peak Total Virtual RAM: 12285.17 Mb, Elapsed Time: 00:00:36.4692722

 

 

 

Possible error "Information: Exception when gathering process information: Interface not registered (Exception from HRESULT: 0x80040155)"

 

- restart Windows Server

- register QVB.exe >> C:\Program Files\QlikView\Distribution Service\qvb.exe > right click > run as Administrator