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 Next Page

Disabling profiling using sa_server_option

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. This section explains how to disable 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.

To disable profiling (Interactive SQL)