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.
Function Determines the time required for a result set to be retrieved.
Location samples-dir\SQLAnywhere\PerformanceFetch
Function Determines the time required for a result set to be retrieved. This tool is similar to fetchtst, but with less functionality.
Location samples-dir\SQLAnywhere\PerformanceFetch
Function Determines the time required for rows to be inserted into a table.
Location samples-dir\SQLAnywhere\PerformanceInsert
Function Measures the load that can be handled by a given database server configuration given a database design and a set of transactions.
Location samples-dir\SQLAnywhere\PerformanceTransaction
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |