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

Viewing procedure profiling information in Sybase Central

Procedure profiling provides you with different information depending whether you choose to look at information for your entire database, a specific type of object, or a particular procedure. The information can be displayed in the following ways:

• details for all profiled objects within the database

• details for all stored procedures and functions

• details for all events

• details for all triggers

• details for individual profiled objects

You must be connected to your database and have profiling enabled to view profiling information.

When you view profiling information for your entire database, the following columns appear:

• Name    lists the name of the object.

• Owner    lists the owner of the object.

• Object Type    lists the type of object, for example, a procedure.

• Table    lists which table a trigger belongs to (this column only appears on the database Profile tab).

• Milliseconds    lists the total execution time for each object.

• Calls    lists the number times each object has been called.

These columns provide a summary of the profiling information for all of the procedures that have been executed within the database. One procedure can call other procedures, so there may be more items listed than those users call specifically.

To view summary profiling information for stored procedures and functions

1. Select the Procedures & Functions folder in the left pane.

2. Click the Profile tab in the right pane.

   Profiling information about all the stored procedures and functions within your database appears on the Profile tab.

To view summary profiling information for events

1. Open the Events folder in the left pane.

   A list of all the events in your database appears on the Events tab in the right pane.

2. Click the Profile tab in the right pane.

   Profiling information about all of the events within your database appears on the Profile tab.

To view summary profiling information for triggers

1. Open the Triggers folder in the left pane.

   A list of all the triggers in your database appears on the Triggers tab.

2. Select the Tables folder in the left pane.

3. Click the Profile tab in the right pane.

   Profiling information about all of the triggers in your database appears on the Profile tab.

Viewing profiling information for a specific procedure