Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SQL Anywhere 12.0.1 » SQL Anywhere Server - SQL Usage » Performance improvements, diagnostics, and monitoring » Performance monitoring and diagnostic tools » Use other diagnostic tools and techniques » Procedure profiling using system procedures

 

Enabling procedure profiling (SQL)

You can enable procedure profiling in Interactive SQL using the sa_server_option system procedure.

Prerequisites

DBA or PROFILE authority.

Context and remarks

Many.

 Enable procedure profiling

  1. Connect to the database.

  2. Call the sa_server_option system procedure, setting the ProcedureProfiling option to ON.

    For example, enter:

    CALL sa_server_option( 'ProcedureProfiling' , 'ON' );

Results

Procedure profiling is enabled.

Next

None.

 See also
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1