SQL Anywhere includes several tools for testing the performance of queries. These tools are stored in subdirectories under %SQLANYSAMP12%\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 information about system procedures that measure query execution times, see sa_get_request_profile system procedure and sa_get_request_times system procedure.
| Tool | Function | Location |
|---|---|---|
| fetchtst | Determines the time required for a result set to be retrieved. | %SQLANYSAMP12%\SQLAnywhere\PerformanceFetch |
| odbcfet | Determines the time required for a result set to be retrieved. This tool is similar to fetchtst, but with less functionality. | %SQLANYSAMP12%\SQLAnywhere\PerformanceFetch |
| instest | Determines the time required for rows to be inserted into a table. | %SQLANYSAMP12%\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. | %SQLANYSAMP12%\SQLAnywhere\PerformanceTransaction |
See also |
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |