The ADMIN COMMAND 'perfmon timers' command produces information about the file operations for each user, and execution times of database operations such as SQL execute. You might run this command to troubleshoot why certain SQL statements take a long time to execute. For more information, see PERFMON TIMERS.
The output can be viewed in two ways:
▪ in the console window by running ADMIN COMMAND'perfmon timers list'
▪ in a report file that is generated by running ADMIN COMMAND 'report report_name'.
In the report file, the timer information is listed under the section PERFORMANCE TIMERS.
The output lists the execution times for each user id.
Additionally, the output includes information for generic users such as Merge, Checkpoint, and Unknown.
▪ The generic users, such as Merge or Checkpoint, refer to operations that use multiple threads. The value shows the combined time for all the multithreaded operations. The total time of such operations can be larger than the elapsed time.
▪ The Unknown user shows the time for system connections that are typically unlisted.
Example usage
Typically, the timers are used by completing the following tasks:
1 Start timers by running ADMIN COMMAND 'perfmon timers start'.
2 Wait for a few minutes (or more).
3 Fetch the current timer values by running one of the following commands:
▪ ADMIN COMMAND 'perfmon timers list'
▪ ADMIN COMMAND 'report report_name'
4 If necessary, wait a few more minutes and then get current timer values again.
5 Stop timers by running ADMIN COMMAND 'perfmon timers stop'.