0 Replies Latest reply: Aug 31, 2010 12:16 PM by alxtoth RSS

    memory usage and source file for running QVB.exe-s

       

      Hi,
      My client runs Publisher on machines with many CPU cores, and runs many jobs in parallel. Some of the reloads might use excessive amounts of memory , and there was no history about wich one, when, how much . So it is hard to fix.
      One can see in QEMC what tasks are running, and one can use Task Manager to see how much memory is used per QVB.exe . While QVB.exe is running you can use tools as Sysinternal's Process Explorer to see what is the working directory, and thefefore know what file is reloading. But once reload is finished, you don't know anymore.
      Simple solution that can be triggered with Windows Task scheduler. Download grep, join, mawk, sed from http://gnuwin32.sourceforge.net/ . Tasklist.exe, handle.exe comes from http://technet.microsoft.com/en-us/sysinternals/default.aspx . Alert limit is 30 Gb in example.
      -Alex
      ==========Script:=======================
      echo %DATE% %TIME% >> mem.txt
      tasklist /V /FO CSV | mawk -F\042 "/[qQ][vV][sSbB]*.exe/ {gsub(/,/,'',$10); if ( int($10) > 30000000) {print $4 , $2 , int($10) '000', $14}}" | sort > tasks.txt
      handle -accepteula qvw.log -p QVB | mawk "/.exe/{print $3, $5 $6 $7 $8 $9 $10 $11}" | sort > handles.txt
      join -a 1 tasks.txt handles.txt | mawk "{print $3, $2, $4, $5 $6 $7 $8 $9 $10 $11}" | sort >> mem.txt
      echo ------------------------------------ >> mem.txt
      del tasks.txt
      del handles.txt
      ====Output==================================
      Thu 08/26/2010 14:21:42.66
      31212980000 QVB.exe QV_SERVICE_ACCOUNT c:\source\sample.qvw.log
      ------------------------------------
      Thu 08/26/2010 14:25:22.32
      33313540000 QVB.exe QV_SERVICE_ACCOUNT c:\source\sample.qvw.log