処理時間表示

set time on
set timing on

※デフォルトで表示される

 

\timing

 

https://qiita.com/maitake9116/items/ed3037badc90de18b0e6

SET STATISTICS TIME ON
go


declare @time datetime2 = sysdatetime()
exec dbo.proc1;
select datediff(millisecond, @time, sysdatetime()) as ms