Allow procedure execution time(s) and rankings to be gathered for the IQ system - very useful in finding bottlenecks, and problematic SQL.
Typically statistics are capture for 30-60 minutes (during peak server activity) and reviewed by the DBAs and developers.
-- Start IQ procedure monitoring
CALL sa_server_option ( 'procedure_profiling', 'ON') ;
-- Run processes for testing, or allow users/apps to hit the server for a set period of time
-- Stop IQ monitoring
CALL sa_server_option ( 'procedure_profiling', 'OFF') ;
-- Run report which lists procedures and execution times
CALL sa_procedure_profile_summary ;
-- Run report which lists procedures and execution times, at the source code (line #) level
CALL sa_procedure_profile ;