Analyzes the request log to determine the execution times of similar statements.
sa_get_request_profile( [ filename [, conn_id [, first_file [, num_files ] ] ] ] )
filename Use this optional LONG VARCHAR parameter to specify the request logging file name.
conn_id Use this optional UNSIGNED INTEGER parameter to specify the ID number of a connection.
first_file Use this optional INTEGER parameter to specify the first request log file to analyze.
num_files Use this optional INTEGER parameter to specify the number of request log files to analyze.
This procedure calls sa_get_request_times to process a request log file, and then summarizes the results into the global temporary table satmp_request_profile. This table contains the statements from the log along with how many times each was executed, and their total, average, and maximum execution times. The table can be sorted in various ways to identify targets for performance optimization efforts.
If you do not specify a log file (filename), the default is the current log file that is specified in the command with -zo, or that has been specified by
sa_server_option( 'RequestLogFile', filename ) |
If a connection ID is specified, it is used to filter information from the log so that only requests for that connection are retrieved.
DBA authority required
Automatic commit
The following command obtains the request times for the requests in the files req.out.3, req.out.4, and req.out.5.
CALL sa_get_request_profile('req.out',0,3,3); |
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |