Where I found out milliseconds for the execution of a query in SQL Server 2008 management studio?

Question

Where I found out milliseconds for the execution of a query in SQL Server 2008 Management Studio?

In Actual Execution Plan I cannot see the time.

Answer 1

use SET STATISTICS TIME ON/OFF in beginning and end of query

Answer 2

Several places:

• sys.dm_exec_query_stats has last_worker_time and last_elapsed_time
• SQL:StmtCompleted captures Duration
• Ditto for RPC:Completed
• Ditto for SP:StmtCompleted
• set statistics time on as Jack already pointed out
• XEvents track basically everything and more.