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 » Application profiling

 

Disabling procedure profiling

Disable procedure profiling when you are finished capturing profiling information for procedures, triggers, and functions. You can delete the profiling information gathered so far if you have already completed your analysis.

Prérequis

You must have the DIAGNOSTICS system role, and the MANAGE PROFILING, SERVER OPERATOR, and SELECT ANY TABLE system privileges.

Contexte et remarques

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.

 Task
  1. In Sybase Central, use the SQL Anywhere 16 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. (Optional) Delete the profiling information gathered so far.

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

    2. Click the Profiling Settings tab.

    3. Click Clear Now.

    4. Click OK.

  5. In the Application Profiling Details pane, click Stop Collecting Profiling Information on Selected Databases.

Résultat

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

 See also