JetstressCmd has an undocumented /report command.

  • Article

JetstressCmd has an undocumented /report command --- which means this function is unsupported.

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).