The solidDB® performance counters (perfmons or pmons) provide information about various database operations and performance. The performance counters are controlled with the ADMIN COMMAND 'perfmon' command.
There are three commands for viewing and collecting performance information:
▪ADMIN COMMAND 'perfmon' returns performance information for the past few minutes at approximately one minute intervals.
▪ADMIN COMMAND 'perfmon diff' collects performance information at given intervals and outputs it into a file in a comma-separated value format.
▪ADMIN COMMAND 'perfmon timers' collects information about execution times of database operations such as SQL execute and file operations for each user.