Event Profiling Procedures

Event profiling procedures return performance statistics for stored procedures, functions, events, and triggers.

Event Profiling Procedures

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 ] ] )

Additional Information

Reference: Building Blocks, Tables, and Procedure > System Procedures > Alphabetical List of Catalog Stored Procedures:
  • sa_server_option system procedure
  • sa_procedure_profile system procedure
  • sa_procedure_profile_summary system procedure
Related concepts
Database Profiling Procedures
Key Performance Indicators
Buffer Cache Performance