Administrator Guide : Monitoring solidDB® : Performance counters (perfmon) : ADMIN COMMAND 'perfmon'
  
ADMIN COMMAND 'perfmon'
The ADMIN COMMAND 'perfmon' command returns a result set of all solidDB® performance counters. For troubleshooting purposes, execute ADMIN COMMAND 'perfmon' during problematic situations or immediately after.
Example output
ADMIN COMMAND 'perfmon';
RC
TEXT
 
 
 
 
 
 
 
 
 
0
----
Performance statistics:
 
 
 
 
 
 
 
 
 
0
Time (sec)
3Q
42
44
30
34
32
32
33
Total
0
File open
: O.Q
O.Q
O.Q
O.Q
O.Q
O.Q
O.Q
O.Q
O.Q
0
File read
: O.Q
O.Q
O.Q
O.Q
O.Q
O.Q
O.Q
O.Q
O.Q
0
File write
: O.Q
O.Q
O.Q
O.Q
O.Q
O.Q
O.Q
O.Q
O.Q
0
File append
: O.Q
O.Q
0.1
O.Q
O.Q
O.Q
0.1
O.Q
O.Q
0
File flush
: O.Q
O.Q
O.Q
O.Q
O.Q
O.Q
O.Q
O.Q
O.Q
0
File lock
: O.Q
O.Q
O.Q
O.Q
O.Q
O.Q
O.Q
O.Q
O.Q
0
Cache find
: O.Q
O.Q
0.5
0.2
0.2
6.1
0.9
O.Q
0.4
0
Cache read
: O.Q
O.Q
O.Q
O.Q
O.Q
O.Q
O.Q
O.Q
O.Q
0
Cache write
: O.Q
O.Q
O.Q
O.Q
O.Q
O.Q
O.Q
O.Q
O.Q
0
Cache prefetch
: O.Q
O.Q
O.Q
O.Q
O.Q
O.Q
O.Q
O.Q
O.Q
0
Cache prefetch wait
: O.Q
O.Q
O.Q
O.Q
O.Q
O.Q
O.Q
O.Q
O.Q
0
Cache preflush
: O.Q
O.Q
O.Q
O.Q
O.Q
O.Q
O.Q
O.Q
O.Q
0
Cache LRU write
: O.Q
O.Q
O.Q
O.Q
O.Q
O.Q
O.Q
O.Q
O.Q
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 is 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 issue ADMIN COMMAND 'perfmon' after each server restart.
ADMIN COMMAND 'perfmon' options
The ADMIN COMMAND 'perfmon' command syntax also has options that allow you to specify output options. For example, you can restrict the output by providing a list of prefixes of counter names ADMIN COMMAND 'perfmon name_prefix_list'.
For example, ADMIN COMMAND 'perfmon db' returns all pmon counters starting 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 ADMIN COMMAND syntax.
See also
Performance counters (perfmon)