Some performance testing utilities, including fetchtst, instest, and trantest, are available in samples-dir\SQLAnywhere. For 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.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|