set statistics time displays information about the time it takes to parse and execute Adaptive Server commands.
Parse and Compile Time 57. SQL Server cpu time: 5700 ms. Execution Time 175. SQL Server cpu time: 17500 ms. SQL Server elapsed time: 70973 ms.
The meaning of this output is:
Parse and Compile Time – The number of CPU ticks taken to parse, optimize, and compile the query. See below for information on converting ticks to milliseconds.
SQL Server cpu time – Shows the CPU time in milliseconds.
Execution Time – The number of CPU ticks taken to execute the query.
SQL Server cpu time – The number of CPU ticks taken to execute the query, converted to milliseconds.
SQL Server elapsed time – The difference in milliseconds between the time the command started and the current time, as taken from the operating system clock.
This output shows that the query was parsed and compiled in 57 clock ticks. It took 175 ticks, or 17.5 seconds, of CPU time to execute. Total elapsed time was 70.973 seconds, indicating that Adaptive Server spent some time processing other tasks or waiting for disk or network I/O to complete.
