Disabling procedure profiling

When you are finished capturing profiling information for procedures, triggers, and functions, you can disable procedure profiling. When you disable procedure profiling, you also have the option to delete the profiling information gathered so far. You may want to do this if you have already completed your analysis work.

Prerequisites

DBA authority.

Context and remarks

If you do not choose to delete profiling data, it remains available for review in Application Profiling mode in Sybase Central, even after procedure profiling is disabled.

 Disable procedure profiling without deleting profiling information (Sybase Central)

  1. Use the SQL Anywhere 12 plug-in to connect to the database.

  2. In the left pane, select the database.

  3. Click Mode » Application Profiling. If the Application Profiling Wizard appears, click Cancel.

  4. In the Application Profiling Details pane, click Stop Collecting Profiling Information On Selected Databases.

 Disable procedure profiling and delete profiling information (Sybase Central)

  1. Use the SQL Anywhere 12 plug-in to connect to the database.

  2. In the left pane, select the database.

  3. Click Mode » Application Profiling. If the Application Profiling Wizard appears, click Cancel.

  4. In the Application Profiling Details pane, select the database and click View Profiling Settings On Selected Databases.

  5. Click the Profiling Settings tab.

  6. Click Clear Now.

  7. Click OK.

Results

Procedure profiling is disabled and profiling information is cleared if specified.

Next

None.

 See also
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1