Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.0 » SQL Anywhere Server - SQL Usage » Monitoring and improving database performance » Improving database performance » Performance improvement tips

 

Monitor query performance

SQL Anywhere includes several tools for testing the performance of queries. These tools are stored in subdirectories under samples-dir\SQLAnywhere, as noted below. Complete documentation about each tool can be found in a readme.txt file that is located in the same folder as the tool. For more information about the location of samples-dir, see Samples directory.

For information about system procedures that measure query execution times, see sa_get_request_profile system procedure and sa_get_request_times system procedure.

 fetchtst
 odbcfet
 instest
 trantest