Find runtime value in SQL Server 2012

Question

I need to found out what query is exactly running in background. after googled, i found below query.

SELECT sqltext.TEXT,req.session_id,req.status,req.start_time,
req.command,req.cpu_time,req.total_elapsed_time
FROM sys.dm_exec_requests req 
CROSS APPLY 
sys.dm_exec_sql_text(sql_handle) AS sqltext

I found out below query using above query.

SELECT count(*) from transaction 
WHERE (TransactionTimestamp between @StartDate and @EndDate)

but i am not able to find what value is passing in @StartDate and @EndDate variable.

is there any way to find out run time value for these variable in Sql Server ?actually this query is triggered by MILESTONE application and user put start date and end date at milestone application. at database end, we need to check what date is provided by user ?

use profiler or extended events – Mitch Wheat Nov 08 '17 at 07:45 — Mitch Wheat, Nov 08 '17 at 07:45
dbcc inputbuffer(@@SpId) – Stanislav Kundii Nov 08 '17 at 08:16 — Stanislav Kundii, Nov 08 '17 at 08:16

score 1 · Accepted Answer · answered Nov 08 '17 at 07:51

1

You can find it using profiler or extended events..

below is small example using profiler

answered Nov 08 '17 at 07:51

TheGameiswar

27,855
8
56
94

1

Excellent !! Thank you so much #TheGameiswar – Manish Gupta Nov 08 '17 at 08:00

Find runtime value in SQL Server 2012

1 Answers1