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 ms. 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 Adaptive 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 Adaptive 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:
