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

Disabling procedure profiling

Once you are finished with the profiling information, you can either disable profiling or you can clear profiling. If you disable profiling, the database stops collecting profiling information and the information that it has collected to that point remains on the Profile tab in Sybase Central. If you clear profiling, the database turns profiling off and removes all the profiling data from the Profile tab in Sybase Central.

To disable 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, clear the Enable Profiling on This Database option.

4. Click OK to close the property sheet.

Note 

You can also right click your database in Sybase Central to disable profiling. From the popup menu, choose Profiling > Stop Profiling.

To disable profiling (SQL)

• Call the sa_server_option stored procedure with the OFF setting.

  For example, enter:

  CALL sa_server_option ('procedure_profiling', 'OFF')

To clear 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 Clear Now.

   You can only clear profiling if profiling is enabled.

4. Click OK to close the property sheet.

To clear profiling (SQL)

• Call the sa_server_option stored procedure with the CLEAR setting.

  For example, enter:

  CALL sa_server_option ('procedure_profiling', 'CLEAR')