solidDB Help : Configuring and administering : Monitoring solidDB : Using performance counters (perfmon) : Collecting recent performance data
  
Collecting recent performance data
The ADMIN COMMAND 'perfmon' command returns the values of all solidDB performance counters. For troubleshooting purposes, run ADMIN COMMAND 'perfmon' during or immediately after problem situations.
Example output
ADMIN COMMAND 'perfmon';
RC TEXT
0 ----
Performance statistics:
0 Time (sec)               30   42   44   30   34   32   32   33   Total
0 File open           :   0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0     0.0
0 File read           :   0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0     0.0
0 File write          :   0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0     0.0
0 File append         :   0.0  0.0  0.1  0.0  0.0  0.0  0.1  0.0     0.0
0 File flush          :   0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0     0.0
0 File lock           :   0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0     0.0
0 Cache find          :   0.0  0.0  0.5  0.2  0.2  6.1  0.9  0.0     0.4
0 Cache read          :   0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0     0.0
0 Cache write         :   0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0     0.0
0 Cache prefetch      :   0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0     0.0
0 Cache prefetch wait :   0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0     0.0
0 Cache preflush      :   0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0     0.0
0 Cache LRU write     :   0.0  0.0  0.0  0.0  0.0  0.0  0.0  0.0     0.0
Each column represents a snapshot of the average performance information for approximately 1 minute. The first row Time (sec) shows the point in time when the snapshot was taken. The Total column shows average information since solidDB was started.
Most values are shown as the average number of events per second. Counters that cannot be expressed as events per second (for example, database size) are expressed in absolute values.
Note The collection of performance data is not persistent over server restarts. To collect performance data, you must run ADMIN COMMAND 'perfmon' after each server restart.
Filtering performance information
The ADMIN COMMAND 'perfmon' command syntax includes an option to restrict the performance information that is returned by providing a list of prefixes of counter names.
For example, ADMIN COMMAND 'perfmon db' returns all pmon counters that start with 'db':
ADMIN COMMAND 'perfmon db';
RC TEXT
0 Performance statistics:
0 Time (sec) 19 Total
0 DBE insert : 0.0 0.0
0 DBE delete : 0.0 0.0
0 DBE update : 0.0 0.0
0 DBE fetch : 0.0 41.2
0 DBE dd operation : 0.0 0.0
0 Db size : 8064 8064
0 Db free size : 7440 7440
0 DB actiongate lock time, latest : 0.0 0.0
0 DB actiongate lock time, sum : 0.0 0.0
0 DB actiongate lock count : 0.0 0.0
12 rows fetched.
For more information about the ADMIN COMMAND 'perfmon' options, see PERFMON.
Go up to
Using performance counters (perfmon)