Viewing Procedure Profiling Statistics

Set the database profiling options in Sybase Central to monitor the execution times of stored procedures, functions, events, and triggers.

Database Profile Properties

Database Profile Properties.

Property Name

Description

Name

Lists the name of the object.

Owner

Lists the owner of the object.

Table

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

Event

Shows the type of trigger for system triggers. This can be Update or Delete.

Type

Lists the type of object, for example, a procedure.

# Exes.

lists the number times each object has been called.

#msecs.

Lists the total execution time for each object.

Related reference
Database Object Profiles
Procedure Profiling Statistics