Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.0 » SQL Anywhere Server - SQL Usage » Monitoring and improving database performance » Improving database performance » Other diagnostic tools and techniques


Reset 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