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

[#1]

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