Re: Creating System Monitoring App - Qlik Community

agni_gold · ‎2014-03-30

Hi,

I am tring to make a basic system monitoring app. That should have following attribute

1. Load time calculation for different different tables

2. RAM Uses during reloading

3. CPU Uses during reloading

4. A trend line for RAM and CPU uses in a chart. time is in dimension.

I have developed a application but I am not able to show trend line . I am attaching my file please have a look on that and please update.

whiteline · ‎2014-03-30

Hi.

It seems that you've uploaded the sample with some wrong data structure.

agni_gold · ‎2014-03-30

No actully i have loaded the data from QVD and Database both and i want to calculate the consumed time during loading . Main Question is how to show the CPU uses chard and RAM uses chart during reload .

whiteline · ‎2014-03-30

You have two separate tables with strange field names that are supposed to be connected.

agni_gold · ‎2014-03-30

sorry for that let me clear

I have a table in database having huge records so what i have done i just loaded that table in first tab and in second tab i have loaded the QVD of same data which i have made previously .

Now i am comparing the time of loading.

in first tab i have taken 2 variable at starting and at end so that it will calculate the time of loading

similarly in second tab and so on .

now when i reload this application reload time is calculated.

simultaneously i want to show the ram uses and cpu uses as in chart in dashboard after reload , so how can i do this

whiteline · ‎2014-03-30

If you have RAM and CPU statistic you have to gather it and then load.

There is no build in tools for that.

Use some monitoring system tool that is able to be managed from QV macro and to store the result in a proper format.

agni_gold · ‎2014-03-30

Can i plot the chart from memory statistics, but this memory statistics can be generated manualy from document properties.is it possible to generate memory statistics automatically?

whiteline · ‎2014-03-30

Hi.

There is API that you can use from macro.

Search for API Guide qvw.

Colin-Albert · ‎2014-03-30

Have a look at this thread.New version of Qlikview Cookbook