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.


DBA or PROFILE authority.

Context and remarks


 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' );


Procedure profiling is enabled.



 See also