Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqadil
Starting Member
11 Posts |
 Posted - 2009-08-17 : 05:24:30
|
| after running the below query with Set statistics time on, select * from mytable,I get the message as belowSQL Server parse and compile time: CPU time = 0 ms, elapsed time = 18 ms.(65 row(s) affected)SQL Server Execution Times: CPU time = 16 ms, elapsed time = 331 ms.What does it mean actually...?Thanks. |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-08-17 : 06:56:09
|
| The first part:SQL Server parse and compile time: CPU time = 0 ms, elapsed time = 18 ms.Tells you how long your query took to parse (Checks for syntax etc), It tells you the CPU time and the total time taken to process.The second part:SQL Server Execution Times:CPU time = 16 ms, elapsed time = 331 ms.Tell you the CPU time and the actual time taken to execute the whole query. So on this query, you used the CPU for 16 milliseconds and it took 331 milliseconds to return the result set (this includes disk I/O, disk queues etc).Hope this helps.. |
 |
|
|
rajdaksha
Aged Yak Warrior
595 Posts |
Posted - 2009-08-17 : 07:01:52
|
| HiThe cpu column in the sysprocesses table is only updated when a query executes with SET STATISTICS TIME ON.-------------------------R... |
|
|
|
sqadil
Starting Member
11 Posts |
Posted - 2009-08-17 : 07:28:42
|
| Thanks a lot to both of you..... so if anyone asks what is the query execution time for this query, then can we say that, this query is taking 331ms or ...? |
|
|
|
|
|
|
Query statistics