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

SQL Anywhere 17 » SQL Anywhere Server - Database Administration » Performance improvements, diagnostics, and monitoring » Performance » Tips for improving performance

Tip: Monitor query performance

Several tools for testing the performance of queries are provided.

Use the Profiler to monitor queries in stored procedures, functions, triggers, and events. The sa_get_request_profile and sa_get_request_times system procedures also measure query execution times.

The following table lists additional tools that are stored in subdirectories under %SQLANYSAMP17%\SQLAnywhere. Complete documentation about each tool can be found in a readme.txt file that is located in the same folder as the tool.

Tool Function Location
fetchtst Determines the time required for a result set to be retrieved. %SQLANYSAMP17%\SQLAnywhere\PerformanceFetch
odbcfet Determines the time required for a result set to be retrieved. This tool is similar to fetchtst, but with less functionality. %SQLANYSAMP17%\SQLAnywhere\PerformanceFetch
instest Determines the time required for rows to be inserted into a table. %SQLANYSAMP17%\SQLAnywhere\PerformanceInsert
trantest Measures the load that can be handled by a given database server configuration given a database design and a set of transactions. %SQLANYSAMP17%\SQLAnywhere\PerformanceTransaction