Some performance testing utilities, including fetchtst, instest, and trantest, are available in samples-dir\SQLAnywhere. For more information about the location of samples-dir, see Samples directory.
The fetchtst utility measures fetch rates for an arbitrary query. The instest utility determines the time required for rows to be inserted into a table. The trantest utility measures the load that can be handled by a given server configuration given a database design and a set of transactions.
These tools give you more accurate timings than the graphical plan with statistics, and can provide an indication of the best achievable performance (for example, throughput) for a given server and database configuration.
Complete documentation for the tools can be found in the readme.txt file in the same folder as the utility.
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |