Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Reference » System Procedures » System procedures

sa_get_histogram system procedure Next Page

sa_get_request_profile system procedure


Analyzes the request log to determine the execution times of similar statements.

Syntax

sa_get_request_profile(
[ filename
[, conn_id
[, first_file
[, num_files ] ] ] ]
)

Arguments
Remarks

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 at the command prompt 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.

Permissions

DBA authority required

Side effects

Automatic commit

Example

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)
See also