--利用getdate
declare @beginTime datetime

declare @endTime datetime

set @beginTime = getdate()

select * from dbo.DatabaseLog

set @endTime = getDate()

select datediff(ms, @beginTime, @endTime) as MS

GO

--利用Statistics
set statistics time on  

select * from dbo.DatabaseLog

set statistics time off