Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 (Français) » SQL Anywhere Server - SQL Usage » Monitoring and Improving Database Performance » Improving database performance » Application profiling


Reset procedure profiling

Reset procedure profiling when you want to clear existing profiling information about procedures, functions, events, and triggers. Resetting does not stop procedure profiling if it is enabled, nor does it start procedure profiling if it is disabled.

♦  To reset profiling (Sybase Central)
  1. Open Sybase Central.

  2. Connect to the database as a user with DBA authority or as a user with PROFILE authority.

  3. In the left pane, select the database.

  4. Choose Mode » Application Profiling. If the Application Profiling Wizard appears, click Cancel.

  5. 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 choose Properties.

  6. Click the Profiling Settings tab.

  7. Click Reset Now.

  8. Click OK.

See also