SQL Server Performance Forum – Threads Archive

SQL Server Execution Times

Hi, where i can find info how to read records bellow?
Thanks
SQL Server Execution Times:
CPU time = 0 ms, elapsed time = 0 ms. SQL Server Execution Times:
CPU time = 0 ms, elapsed time = 0 ms. SQL Server Execution Times:
CPU time = 0 ms, elapsed time = 0 ms.
SQL Server parse and compile time:
CPU time = 328 ms, elapsed time = 573 ms. (51 row(s) affected) Warning: Null value is eliminated by an aggregate or other SET operation.
Table â€˜Table1#%92. Scan count 1, logical reads 39245, physical reads 3, read-ahead reads 41384.
Table â€˜Table2#%92. Scan count 1, logical reads 161928, physical reads 2, read-ahead reads 162444.
Table â€˜Table3#%92. Scan count 1, logical reads 24, physical reads 0, read-ahead reads 24.
Table â€˜Table4#%92. Scan count 1, logical reads 875, physical reads 2, read-ahead reads 875. SQL Server Execution Times:
CPU time = 27641 ms, elapsed time = 61092 ms. SQL Server Execution Times:
CPU time = 27641 ms, elapsed time = 61094 ms. SQL Server Execution Times:
CPU time = 27641 ms, elapsed time = 61099 ms.
SQL Server parse and compile time:
CPU time = 0 ms, elapsed time = 0 ms.

http://www.sql-server-performance.com/query_execution_plan_analysis.asp &http://www.sql-server-performance.com/statistics_io_time.asp fyi. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

Thank you

]]>