Procedure Profile

sa_procedure_profile reports information about the execution time for each line within procedures, functions, events, or triggers executed in a database.

sa_procedure_profile statistics
Column name	Description
object_type	Identifies the object type: P (Stored procedure) F (Function) T (Trigger) E (Event) S (System trigger)
object_name	Lists the name of the object.
owner_name	Lists the owner of the object.
table_name	Identifies the table associated with a trigger (the value is NULL for other object types).
Line_number	Identifies the line number within the procedure.
executions	Lists the number of times the object has been called
Milliseconds	Lists the objects execution time
percentage	Identified the percentage of the total execution time required for the specific line.
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.

Setting Database Profiling Options with Interactive SQL
Use sa_server_option to set database profiling options in Interactive SQL. Your server must be running, and you must have DBA authority, and be connected to a database.
Generating Profiling Information with Interactive SQL
sa_procedure_profile and sa_procedure_profile_summary generate execution statistics for procedures, functions, events, and triggers.

Parent topic: Procedure Profiling Statistics