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

 

Disabling procedure profiling (SQL)

You can disable procedure profiling and clear existing data from Interactive SQL using the sa_server_option system procedure.

Prerequisites

DBA or PROFILE authority.

Context and remarks

Once you are finished with the profiling information, you can either disable profiling or you can clear profiling. If you disable profiling, the database stops collecting profiling information and the information that it has collected to that point remains on the Profile tab in Sybase Central. If you clear profiling, the database turns profiling off and clears all the profiling data from the Profile tab in Sybase Central.

 Disable profiling

  • Call the sa_server_option system procedure, setting the ProcedureProfiling option to OFF.

    For example, enter:

    CALL sa_server_option( 'ProcedureProfiling' , 'OFF' );
 Disable profiling and clear existing data

  • Call the sa_server_option system procedure, setting the ProcedureProfiling option to CLEAR.

    For example, enter:

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

Results

Procedure profiling is disabled and the profiling data is cleared if the option CLEAR has been used.

Next

None.

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