Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Usage » Performance improvements, diagnostics, and monitoring » Performance monitoring and diagnostic tools » 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.

Prerequisites

You must have the DIAGNOSTICS system role, and the MANAGE PROFILING system privilege.

Procedure profiling must be enabled.

 Task

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

    For example, execute the following CALL statement:

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

Results

Procedure profiling is reset.

 See also
Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0