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

Enabling procedure profiling

You can enable profiling in either Sybase Central or Interactive SQL. You must have DBA authority to enable and use procedure profiling.

To enable profiling (Sybase Central)

1. Connect to your database as a user with DBA authority.

2. Select the database in the left pane.

3. From the File menu, choose Properties.

   The Database property sheet appears.

4. On the Profiling tab, select Enable Profiling on This Database.

5. Click OK to close the property sheet.

Note 

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

To enable profiling (SQL)

1. Connect to your database as a user with DBA authority.

2. Call the sa_server_option stored procedure with the ON setting.

   For example, enter:

   CALL sa_server_option ( 'procedure_profiling', 'ON')