Check your query performance.

Set NoCount On


Declare @cpu_ int

Declare @lreads_ int

Declare @eMsec_ int





Select @cpu_ = cpu_time

, @lreads_ = logical_reads

, @eMsec_ = total_elapsed_time

From sys.dm_exec_requests

Where session_id = @@spid



--======

-- Your Test Code Goes Here

--======

Select cpu_time-@cpu_ as CpuMs

, logical_reads- @lreads_ as LogRds

, total_elapsed_time - @eMsec_ as Elapsed

From sys.dm_exec_requests

Where session_id = @@spid