ASA SQL User's Guide
Monitoring and Improving Performance
Procedure profiling shows you how long it takes your stored procedures, functions, events, and triggers to execute. You can also view the execution time for each line of a procedure. Using the database profiling information, you can determine which procedures can be fine-tuned to increase performance within your database.
When profiling is enabled, Adaptive Server Anywhere monitors which stored procedures, functions, events, and triggers are used, keeping track of how long it takes to execute them, and how many times each one is called.
Profiling information is stored in memory by the server and can be viewed in Sybase Central via the Profile tab or in Interactive SQL. Once profiling is enabled, the database gathers profiling information until you disable profiling or until the server is shut down.
For more information about obtaining profiling information in Interactive SQL, see Viewing procedure profiling information in Interactive SQL.
Enabling procedure profiling
Resetting procedure profiling
Disabling procedure profiling
Viewing procedure profiling information in Sybase Central
Viewing procedure profiling information in Interactive SQL