The statement performance summary feature returns execution times for statements when troubleshooting slow statement performance. The SQL Anywhere Profiler uses this feature to display the statement performance summary results.
The statement performance summary feature uses the sp_top_k_statements and sp_find_top_statements system procedures to report the statement/plan combinations that take the longest time to run.
The SQL for statements with a maximum runtime of 0.005 seconds or higher can be found in the GTSYSPERFCACHESTMT system view. The graphical plan for every statement or plan with the maximum runtime of 0.05 seconds can be found in the GTSYSPERFCACHEPLAN system view.
To disable statement performance summary collection on a single database, set the CollectStmtPerfStats option of the sa_db_option system procedure. Setting this option requires MONITOR privileges.
The statement performance summary feature only maintains information for a maximum of 10,000 statements with the highest maximum runtimes.