SQL Server:SET STATISTICS TIME ON

SET STATISTICS TIME ON

Displays the number of milliseconds required to parse, compile and execute SQL statements.

EXAMPLE

USE Adventureworks

SET STATISTICS TIME ON

SELECT * FROM Production.Product

SET STATISTICS TIME OFF

Results: (You can view the results in the Message Pane i.e. next to Results Pane)

SQL Server parse and compile time:

CPU time = 0 ms, elapsed time = 50 ms.

(504 row(s) affected)

SQL Server Execution Times:

CPU time = 0 ms, elapsed time = 668 ms