ASA SQL User's Guide
Monitoring and Improving Performance
Performance analysis tools
Some performance testing utilities, including fetchtst, instest, and trantest, are available in the <installation dir>\samples\asa\ directory. Complete documentation can be found in the Readme.txt file in the same folder as the utility. These tools will give you more accurate timings than the graphical plan with statistics. These utilities can provide an indication of the best achievable performance (for example, throughput) for a given server and database configuration.
Fetchtst measures fetch rates for an arbitrary query. Instest determines the time required for rows to be inserted into a table. Trantest measures the load that can be handled by a given server configuration given a database design and a set of transactions.