Contents Index Viewing procedure profiling information in Interactive SQL Queries: Selecting Data from a Table

ASA SQL User's Guide
  Monitoring and Improving Performance
    Profiling database procedures
      Viewing procedure profiling information in Interactive SQL

Viewing profiling information for a specific procedure in Interactive SQL

The sa_procedure_profile stored procedure provides information about individual lines within specific procedures. The result set includes the line number, execution time, and percentage of total execution time for lines within procedures. You can use the following parameters to restrict the rows the procedure returns:

If you do not include any parameters in your query, the procedure returns profiling information for all the procedures that have been called.

To view profiling information for specific lines within procedures

  1. Execute the sa_procedure_profile stored procedure.

    For example, enter:

    CALL sa_procedure_profile
  2. From the SQL menu, choose Execute.

    A result set with profiling information for individual procedure lines appears on the Results tab in the Results pane.

For more information about the sa_procedure_profile stored procedure, see sa_procedure_profile system procedure.


Contents Index Viewing procedure profiling information in Interactive SQL Queries: Selecting Data from a Table