Administrator Guide : Monitoring solidDB® : Performance counters (perfmon) : ADMIN COMMAND 'perfmon diff': Producing a continuous performance monitoring report
  
ADMIN COMMAND 'perfmon diff': Producing a continuous performance monitoring report
The command ADMIN COMMAND 'perfmon diff' allows you to start and stop producing continuous performance counter reports to a file.
Starting continuous performance reporting
To start collecting performance counter information, issue the following command:
ADMIN COMMAND 'perfmon diff start filename interval'
where
▪filename is the name of the output file. The performance data is output in comma-separated value format; the first row contains the counter names, and each subsequent row contains the performance data per each sampling time. The default file name is pmondiff.out.
▪interval is the interval in milliseconds at which performance data is collected. The default interval is 1000 ms.
If the continuous performance reporting is already enabled, the ADMIN COMMAND 'perfmon diff start' command returns the following result set:
RC TEXT
-- ----
0 Pmon diff output already active.
1 rows fetched.
Starting continuous performance reporting
To stop the collection of performance data, issue the following command.
ADMIN COMMAND 'pmon diff stop'
To check the status of continuous performance reports
Example
To start logging performance counters in to the counter_log.csv file with 2 second interval, issue the following command:
ADMIN COMMAND 'pmon diff start counter_log.csv 2000'
See also
Performance counters (perfmon)