Returns server performance counters for the past few minutes at approximately one minute intervals. 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.
▪ -c: Prints actual counter values for each snapshot.
▪ -r: Prints counter values in raw mode, which includes only the latest counter values without any formatting. The counter names are not printed. This option is useful if actual monitoring is performed using some other external program that retrieves the counter values from the server. You can retrieve the counter names with the --xnames option.
▪ print_options: One or more of the following values:
▪ -xtime: Prints the time in seconds
▪ -xtimediff: Prints the difference to the last pmon call in milliseconds
▪ -xnames: Prints out the column names for the output
▪ -xdiff: Indicates the difference to the last ADMIN COMMAND 'perfmon' execution instead of the absolute value
▪ name_prefix_list: Limits the output to specific counter types, as indicated by the first word in the counter name. For example, to print all file-related counters, the name_prefix_list should be file. You can also specify multiple prefixes.
The following example returns all information:
ADMIN COMMAND 'perfmon'
The following example returns all values for counters whose name starts with prefix File and Cache.