isql provides a performance statistics option (-p).
For example, this syntax returns the following statistics:
isql -p 1> select * from sysobjects 2> go Execution Time (ms.): 1000 Clock Time (ms.): 1000 1 xact:
This means that a single transaction took 100 milliseconds. The clock time value reflects the entire transaction, which starts when Client-Library™ builds the query and ends when Client-Library returns the information from the SAP ASE server.
You can gather performance statistics based on the execution of one or more transactions. To gather statistics on more than one transaction, specify a number after the command terminator.
For example, the following command instructs the SAP ASE server to execute three select * transactions and report the performance statistics:
isql -p 1> select * from sysobjects 2> go 3 Execution Time (ms.): 1000 Clock Time (ms.): 1000 Execution Time (ms.): 1000 Clock Time (ms.): 2000 Execution Time (ms.): 1000 Clock Time (ms.): 1000 Execution Time (ms.): 1000 Clock Time (ms.): 4000 3xact: