JetstressCmd has an undocumented /report command

  • Article

NOTE: This is reposted here from HMLee’s blog back in 2007 – he is no longer posting to the blog and I wanted to keep this post just in case his blog gets deleted – after all, it is useful information, I have a brain like a sieve and this is probably as good as place to store it as any…

This /report command allows you to regenerate the Jetstress HTML report given just the BLG file and some information about the test system. This can be extremely useful in certain situations Smile

I couldn't publish a neat command interface due to a tight schedule for this function. The program should be able to find all the arguments such as machine name, process name, process id, and start and end times. But, it currently requires you to specify so many arguments about the host machine.

D:\Jetstress\JetstressCmd.exe /c JetstressConfig.xml /report "ROSWELL; JetstressWin; 0; Performance_2007_5_30_10_13_54.blg; 5/30/2007 10:15:49 AM; 5/30/2007 12:15:51 PM”

5/31/2007 12:59:31 AM -- Command Line: D:\Jetstress\JetstressCmd.exe /c JetstressConfig.xml /report "ROSWELL; JetstressWin; 0; Performance_2007_5_30_10_13_54.blg; 5/30/2007 10:15:49 AM; 5/30/2007 12:15:51 PM"
5/31/2007 12:59:31 AM -- Database read latency thresholds: (average: 0.02 seconds/read, maximum: 0.05 seconds/read).
5/31/2007 12:59:31 AM -- Log write latency thresholds: (average: 0.01 seconds/write, maximum: 0.05 seconds/write).
5/31/2007 12:59:32 AM -- Creating test report ...
5/31/2007 12:59:37 AM -- Volume F: has 0.0000 for Avg. Disk sec/Read.
5/31/2007 12:59:37 AM -- Volume G: has 0.0000 for Avg. Disk sec/Read.
5/31/2007 12:59:37 AM -- Volume H: has 0.0000 for Avg. Disk sec/Write.
5/31/2007 12:59:37 AM -- Volume H: has 0.0000 for Avg. Disk sec/Read.
5/31/2007 12:59:37 AM -- Volume I: has 0.0000 for Avg. Disk sec/Write.
5/31/2007 12:59:37 AM -- Volume I: has 0.0000 for Avg. Disk sec/Read.
5/31/2007 12:59:37 AM -- Test has 0 Maximum Database Page Fault Stalls/sec.
5/31/2007 12:59:37 AM -- Test has 0 Database Page Fault Stalls/sec samples higher than 0.
5/31/2007 12:59:37 AM -- Performance_2007_5_30_10_13_54.xml has 479 samples queried.

ROSWELL is the machine name that is part of performance counters and instances.

JetstressWin is the process name that is part of Jet database performance counter instance names. You have to specify JetstressCmd if JetstressCmd has the performance log generated.

0 is the process id that is part of Jet database performance counter instance names. You don’t have to specify the process id unless you used NAS (network attached storage).