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)
Select the database in the left pane.
From the File menu, choose Properties.
The Database property sheet appears.
On the Profiling tab, click Reset Now.
Click OK to close the property sheet.
You can also right click your database in Sybase Central to reset profiling. From the popup menu, click Profiling > Reset Profiling Information.
Call the sa_server_option stored procedure with the RESET setting.
For example, enter:
CALL sa_server_option ('procedure_profiling', 'RESET')
