Resetting profiling using sa_server_option

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

The following sections assume that you are already connected to your database as the DBA, or as a user with PROFILE authority, and that procedure profiling is enabled.

To reset profiling in Interactive SQL

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

    For example, enter:

    CALL sa_server_option( 'ProcedureProfiling' , 'RESET' );
See also
Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0