ASA SQL User's Guide
  Monitoring and Improving Performance
    Profiling database procedures

Resetting procedure profiling

When you reset profiling, the database clears the old information and immediately starts collecting new information about procedures, functions, events, and triggers.

The following sections assume that you are already connected to your database as a user with DBA authority and that procedure profiling is enabled.

To reset profiling (Sybase Central)

1. Select the database in the left pane.

2. From the File menu, choose Properties.

   The Database property sheet appears.

3. On the Profiling tab, click Reset Now.

4. Click OK to close the property sheet.

Note 

You can also right click your database in Sybase Central to reset profiling. From the popup menu, click Profiling > Reset Profiling Information.

To reset profiling (SQL)

• Call the sa_server_option stored procedure with the RESET setting.

  For example, enter:

  CALL sa_server_option ('procedure_profiling', 'RESET')