iAnywhere.com - Resetting profiling using sa_server

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

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Usage » Monitoring and Improving Performance » Other diagnostic tools and techniques » Procedure profiling using system procedures

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.

For more information on the syntax of, and results returned by, this system procedure, see sa_server_option system procedure.

The following sections assume that you are already connected to your database as the DBA 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' );
```