How to enable QlikView QIX performance logging

Chip_Matejowsky — Wed, 02 Jun 2021 12:41:26 GMT

QlikView November 2018 introduces QIX performance logging (telemetry). The QIX performance log provides detailed information on the QIX Engine performance. By default, the QIX Performance log file is disabled.

! See more details on the output provided on the official Qlik Help site.

Note that enabling this will lead to a large amount of data being written to disk.

Environment:

Resolution:

Enabling the QIX performance log

To enable the QIX performance log, you must add the line QixPerformanceLogVerbosity to the QlikView Server Service (QVS) Settings.ini file, followed by the desired level of verbosity. For example:

QixPerformanceLogVerbosity=3

The levels of verbosity for the QIX performance log are as follows:

0 = Off
1 = Fatal
2 = Error
3 = Warning
4 = Info
5 = Debug

If you enable the QIX performance log, and set QixPerformanceLogVerbosity to level 3 or 2, the following four threshold parameters must also be added to the Settings.ini file:

WarningProcessTimeMs

ErrorProcessTimeMs

WarningPeakMemory

ErrorPeakMemory

To set QIX Performance logging for the Warning level, perform the following steps:

Stop the QlikView Server service
Open the QlikView Server Service (QVS) Settings.ini file, which by default is located in:
%ProgramData%\QlikTech\QlikViewServer
Add the following line under the [Settings 7]:

QixPerformanceLogVerbosity=3
Enter desired values for the four measurement levels

WarningProcessTimeMs=30000
ErrorProcessTimeMs=60000
WarningPeakMemory= 1073741824
ErrorPeakMemory= 2147483648
Save the Settings.ini file
Restart the QlikView Server Service (QVS)

Parameter Descriptions

ErrorPeakMemory: Default 2147483648 bytes (2 Gb). If an engine operation requires more than this value of Peak Memory, a record is logged with log level ‘error’. Peak Memory is the maximum, transient amount of RAM an operation uses.
WarningPeakMemory: Default 1073741824 bytes (1 Gb). If an engine operation requires more than this value of Peak Memory, a record is logged with log level ‘warning’. Peak Memory is the maximum, transient amount of RAM an operation uses.
ErrorProcessTimeMs: Default 60000 millisecond (60 seconds). If an engine operation requires more than this value of process time, a record is logged with log level ‘error’. Process Time is the end-to-end clock time of a request.
WarningProcessTimeMs: Default 30000 millisecond (30 seconds). If an engine operation requires more than this value of process time, a record is logged with log level ‘warning’. Process Time is the end-to-end clock time of a request.

Note that it is possible to track only process time or peak memory. It is not required to track both metrics. However, if you set ErrorPeakMemory, you must set WarningPeakMemory. If you set ErrorProcessTimeMs, you must set WarningProcessTimeMs.

Output file

The QIX Performance log will be written to the directory as configured for QlikView Server logging in the QlikView Management Console > System > Setup > QlikView Server > QVS@ > Logging tab > Log Folder section. The naming convention of the log will be as <Servername>_QixPerformance_Engine.log

Performance note

The QIX performance logging produces heavy logging, especially when the setting is 4 or 5. These values are intended to do complex troubleshooting during a short interval of time.