Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

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


Community Browser