Event profiling procedures return performance statistics for stored procedures, functions, events, and triggers.
Name |
Description |
---|---|
sa_server_option |
Sets database profiling options in Interactive SQL.
Usage:
CALL sa_server_option ( 'procedureprofiling', 'ON') |
sa_procedure_profile |
Returns execution times for each line in database procedures,
functions, events, or triggers.
Usage:
sa_procedure_profile [ filename [, save_to_file ] ] ) |
sa_procedure_profile_summary |
Summarizes execution times for all procedures, functions, events,
or triggers.
Usage:
sa_procedure_profile_summary [ filename [, save_to_file ] ] ) |