kedzior-io

-- From : Michael J Swart (https://sqlperformance.com/2017/07/sql-performance/find-database-connection-leaks)

declare @database_name sysname = N'YOUR_DATABASE_NAME_HERE';
declare @program_name sysname = N'.Net SqlClient Data Provider';

select 
	datediff(SECOND, s.last_request_end_time, getdate()) as seconds_asleep,
	s.last_request_start_time as lastreq,
        s.session_id,
        db_name(s.database_id) as database_name,