topic Re: Creating System Monitoring App in QlikView

Creating System Monitoring App

agni_gold — Sun, 30 Mar 2014 06:37:02 GMT

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.

Re: Creating System Monitoring App

whiteline — Sun, 30 Mar 2014 09:04:42 GMT

Hi.

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

Re: Creating System Monitoring App

agni_gold — Sun, 30 Mar 2014 09:26:13 GMT

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 .

Re: Creating System Monitoring App

whiteline — Sun, 30 Mar 2014 09:28:58 GMT

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

Re: Creating System Monitoring App

agni_gold — Sun, 30 Mar 2014 09:55:10 GMT

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

Re: Creating System Monitoring App

whiteline — Sun, 30 Mar 2014 09:59:47 GMT

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.

Re: Creating System Monitoring App

agni_gold — Sun, 30 Mar 2014 10:07:44 GMT

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?

Re: Creating System Monitoring App

whiteline — Sun, 30 Mar 2014 17:02:07 GMT

Hi.

There is API that you can use from macro.

Search for API Guide qvw.

Re: Creating System Monitoring App

Colin-Albert — Sun, 30 Mar 2014 17:46:22 GMT

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