Set STATISTICS PROFILE on
SET STATISTICS IO on
Set STATISTICS TIME on
Go
< Write your statement here ...>
Go
Set STATISTICS profile off
SET STATISTICS IO off
Set STATISTICS time off
In the following message, you will see:
SQL Server parse and compile time:
CPU time = 0 milliseconds, elapsed time = 0 milliseconds.
(1000 rows affected)
Table ' Memberlevelglide '. Scan count 2, logical read 1205 times, physical read 0 times, read 0 times, LOB logic read 0 times, lob physical read 0 times, lob read 0 times.
(9 rows affected)
SQL Server Execution Time:
CPU time = 31 milliseconds, elapsed time = 217 milliseconds.
SQL Server parse and compile time:
CPU time = 0 milliseconds, elapsed time = 0 milliseconds.
SQL Server Execution Time:
CPU time = 0 milliseconds, elapsed time = 0 milliseconds.
SQL Server Execution Time:
CPU time = 0 milliseconds, elapsed time = 0 milliseconds.