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 » Application profiling » Procedure profiling in Application Profiling mode

Resetting procedure profiling Next Page

Disabling procedure profiling

Once 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.

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.

To disable profiling without deleting profiling information

  1. Switch to Application Profiling mode. If the Application Profiling wizard appears, click Cancel to close it.

  2. Select the database in the Application Profiling Details area (lower pane), and click Stop Collecting Profiling Information on Selected Databases.

    The database server stops collecting profiling information.

    3. To delete profiling information and disable procedure profiling

    1. Switch to Application Profiling mode. If the Application Profiling wizard appears, click Cancel to close it.

    2. In the Application Profiling Details pane, select the desired database, and then click View Profiling Settings on Selected Databases.

      The Database property sheet appears.

    3. On the Profiling Settings tab, click Clear Now.

      Procedure profiling is disabled (notice that the checkmark is cleared from Capture and View Profiling Information in this Database for) and profiling data is removed from the database.

    4. Click OK to close the property sheet.

    See also