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


Resetting procedure profiling

Reset procedure profiling when you want to clear existing profiling information about procedures, functions, events, and triggers. You do not have to disable procedure profiling to reset it.


You must be running the network server (dbsrv), not the personal server (dbeng).

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

Context and remarks


Resetting does not stop procedure profiling if it is enabled, nor does it start procedure profiling if it is disabled.

  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. Choose one of the following:

    Option Action

    If procedure profiling is enabled

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

    If procedure profiling is not enabled

    In the left pane, right-click the database and click Properties.

  5. Click the Profiling Settings tab.

  6. Click Reset Now.

  7. Click OK.


Procedure profiling is reset and existing profile information is cleared.

 See also