The solidDB performance counters (perfmons or pmons) provide information about various database operations and performance. The following ADMIN COMMANDs enable you to view and collect performance information:
▪ ADMIN COMMAND 'perfmon' returns performance information for the past few minutes at approximately one minute intervals, see PERFMON.
▪ ADMIN COMMAND 'perfmon diff' collects performance information at given intervals and saves it to a file in a comma-separated value format, see PERFMON DIFF.
▪ ADMIN COMMAND 'perfmon timers' collects information about execution times of database operations such as SQL execute and file operations for each user, see PERFMON TIMERS.
▪ ADMIN COMMAND 'perfmon list' prints out the short explanation of all solidDB performance counters, see PERFMON LIST.