CPU, memory utilization etc. of the qlikview server

[#1]

We are trying to create a monitoring tool to show CPU, memory utilization etc. of the qlikview server. While opening the "QVGD_Performance_2.0.1.qvd" file using EasyQlik QViewer tool to check the CPU utilization, we found CPULoad header and found some distinct values like 0, 1, 2, 4 …  Is this the CPU utilization percentage for a specific timestamp? Screen shot attached(name = QvdFile).

While opening the "QVGD_Performance_2.0.1.qvd" file in Notepad++, it looks like a xml file and we found some tag name like <BitOffset>, <BitWidth>, <NoOfSymbols>, <Offset>, <Length>. Could you please describe the significance of these fields? Screen shot attached(name = CPULoad).

[engishfaque]

Dear Somnath,

QlikView Data File (QVD) is actually an eXtensible Markup Language (XML) file format. So, whenever you open the file in Text Editor it will show you metadata like(parent tags, child tags, values etc) same as other XML files consist on.

EasyQlik QViewer tool is a viewer tool and specially designed and develop for to view the QVDs files, means QViewer parsed the data from XML to normal table file format when you open any QVD. However, QVD does not change their format after opening QVD into QViewer.

So, If you are trying to create a monitoring tool for CPU, Memory Utilization etc. You need to create XML parser in your Monitoring tool for parsing purpose as the values can be parsed properly from XML to your required format (table format etc).

Kind regards,

Ishfaque Ahmed

[#3]

Hi Ishfaque,

Thank you so much for your answer, it is really helpful.

To display CPU / Memory utilization in our dashboard, we will be parsing "QVGD_Performance_2.0.1.qvd" file. In the above qvd file, we found “CPULoad” tag. As per our understanding, this field name is the CPU utilization but unable to find the exact tag that represents the CPU utilization percentage.

Requesting you to help us in this matter.

Thank you.

[#4]

Hi Ishfaque,

Can you please suggest any java library which we can use to parse the qvd file data and fetch the details of CPU and Memory details. We are trying to parse the data in java.

Thank you.

[engishfaque]

Dear Somnath,

Have a look into given below links,

1. irregular.bi blog - QlikView data integration in a Java world with QVX... - A Blog about BI and Data...

2. QlikView_QVDReader_Examples/ExampleQVDReader.java at master · ralfbecher/QlikView_QVDReader_Examples...

3. QVX &amp; QVD Converter Java library

4. Extract data from QVD file into JAVA Bean | Qlik Community

5. QVX &amp; QVD Converter Java library

6. Create a .qvd with Java

7. QVD Converter

Kind regards,

Ishfaque Ahmed

[#6]

Hi Ishfaque,

Thank you so much for your time and help, I am good enough to parse the data from qvd to csv using java.

We are now able to get the details of utilization of cpu and memory of server by parsing the "QVGD_Performance_2.0.1.qvd" file.

can you please tell us how could we get the details of utilization of memory and cpu of each qlikview dashboard? means we want to know the utilization of cpu and memory in each qlikview dashboard wise.

Can you please tell us which qvd file we should refer?

Requesting to you please help in this matter.

Thank you.