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


Resetting procedure profiling (SQL)

When you reset profiling, the database clears the old information and immediately starts collecting new information about procedures, functions, events, and triggers. You can reset procedure profiling from Interactive SQL using the sa_server_option system procedure.


DBA or PROFILE authority.

Ensure that procedure profiling is enabled.

Context and remarks


 Reset procedure profiling
  • Call the sa_server_option system procedure, setting the ProcedureProfiling option to RESET.

    For example, enter:

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


Procedure profiling is reset.



 See also