title: What does SQL Server Execution Times represent?
body: <p>I have a query that I'm running on two equivalent databases, but hosted on separate MS SQL 2005 servers. I want to measure the time of a query on both servers, and thus tried the following: </p>
  
  <pre><code>SET STATISTICS TIME ON
  GO
  SELECT TOP 10000 *
    FROM table
  GO
  SET STATISTICS TIME OFF;
  GO
  </code></pre>
  
  <p>And got the following result:</p>
  
  <pre><code>SQL Server parse and compile time: 
     CPU time = 0 ms, elapsed time = 2 ms.
  
  (10000 row(s) affected)
  
  SQL Server Execution Times:
     CPU time = 16 ms,  elapsed time = 8143 ms.
  SQL Server parse and compile time: 
     CPU time = 0 ms, elapsed time = 0 ms.
  </code></pre>
  
  <p>My question is, what does SQL Server Execution Times mean? Is it the execution of the query at the database only, or is it the execution of the query including the transport of data back to the client running SQL Server Management Studio?</p>
  
  <p>Thanx in advance!</p>