Set the database profiling options, then use the profiling options to return performance statistics for stored procedures, functions, events, and triggers.
sa_procedure_profile_summary is a system procedure that reports summary information about the execution times for all procedures, functions, events, or triggers that have been executed in a database. This procedure provides the same information for these objects as the Profile tab in Sybase Central.
Column name |
Description |
|---|---|
object_type |
Identifies the object type:
|
object_name |
Lists the name of the object. |
executions |
Lists the number times each object has been called. |
owner_name |
Lists the owner of the object. |
table_name |
Specifies which table to profile triggers. |
executions |
Lists the number of times the object has been called. |
Milliseconds |
Identifies the time to execute the line, in milliseconds. |
foreign_owner |
Identifies the database user who owns the foreign table for a system trigger. |
foreign_table |
Identifies The name of the foreign table for a system trigger. |