SELECT [dd hh:mm:ss.mss]
,[start_time]
,[collection_time]
,[session_id]
,[sql_text]
,[sql_command]
,[login_name]
,[wait_info]
,[tran_log_writes]
,[CPU]
,[tempdb_allocations]
,[tempdb_current]
,[blocking_session_id]
,[reads]
,[writes]
,[physical_reads]
,[query_plan]
,[used_memory]
,[status]
,[tran_start_time]
,[open_tran_count]
,[percent_complete]
,[host_name]
,[database_name]
,[program_name]
,[login_time]
,[request_id]
,[collection_time]
FROM [DBAtools].[dbo].[WhoIsActive]
WHERE
CONVERT(CHAR(8),COLLECTION_time,8) BETWEEN '00:00:00' AND '23:00:00' AND
datepart(YEAR,start_time) BETWEEN 2020 AND 2020 and
datepart(month,start_time) BETWEEN 04 AND 04 and
datepart(day,start_time) BETWEEN 22 AND 23
and [dd hh:mm:ss.mss] > '00 01:00:00.0000'
Similar Posts: