How to get CPU usage per document from System Monitor dashboard ?

Mon, 07 Apr 2014 11:16:32 GMT

Hi All,

Any idea about how to get CPU usage per document from System Monitor dashboard ?

Thanks in advance

Re: How to get CPU usage per document from System Monitor dashboard ?

Mon, 07 Apr 2014 11:40:34 GMT

Hi Nayana

I solve this trouble with the solution above:

Monitor´s Dashboard sweep Qlikview access Log Files. So at any application in extract layer I search for those files with this basic function

Sub readFiles (root)
    For each File in filelist ('$(root)\Sessions*.log')
    vsFileCheck = index(File,'~$');
        if vsFileCheck=0 then
            Acessos:
  LOAD [Exe Type],
      [Exe Version],
      [Server Started],
      Timestamp,
      Document,
      [Document Timestamp],
      [QlikView User],
      [Exit Reason],
      [Session Start],
      [Session Duration],
      [CPU spent (s)],
      [Bytes Received],
      [Bytes Sent],
      Calls,
      Selections,
      [Authenticated user],
      [Identifying user],
      [Client machine identification],
      [Serial number],
      [Client Type],
      [Client Build Version],
      [Secure Protocol],
      [Tunnel Protocol],
      [Server Port],
      [Client Address],
      [Client Port],
      [Cal Type],
      [Cal Usage Count]
  FROM
      [$(File)] (txt, utf8, embedded labels, delimiter is '\t', msq);
    endif
  Next File;
   
  //Se não tiver arquivos de log, carrega uma estrutura vazia pra não deixar no vácuo
    Acessos:
  LOAD * INLINE
  [
  Exe Type,Exe Version,Server Started,Timestamp,Document,Document Timestamp,QlikView User,Exit Reason,Session Start,Session Duration,CPU spent (s),Bytes Received,Bytes Sent,Calls,Selections,Authenticated user,Identifying user,Client machine identification,Serial number,Client Type,Client Build Version,Secure Protocol,Tunnel Protocol,Server Port,Client Address,Client Port,Cal Type,Cal Usage Count
  ]; 
  //Armazena no arquivo QVD
  store Acessos into DADOS\Acessos.qvd;
  //Apaga tabela residente
  drop table Acessos;
End sub;

After that call pointing to access log directory´s as a parameter

call readFiles('C:\ProgramData\QlikTech\QlikViewServer')

The final QVD file created in this function will be contains many information about documents, CPU, memory profiles and session time by user and application and can be transformed and displayed in any application.

Hope this helps

topic How to get CPU usage per document from System Monitor dashboard ? in QlikView

How to get CPU usage per document from System Monitor dashboard ?

Re: How to get CPU usage per document from System Monitor dashboard ?