with tb as ( select --blocking_session_id, session_id,db_name(database_id) as dbname,text from master.sys.dm_exec_requests a With(nolock) CROSS APPLY master.sys.dm_exec_sql_text(a.sql_handle) ), tb1 as ( select a.*,login_time,program_name,client_interface_name,login_name,cpu_time,memory_usage*8 as 'memory_usage(KB)', total_scheduled_time,reads,writes,logical_reads from tb a inner join master.sys.dm_exec_sessions b With(nolock) on a.session_id=b.session_id ) select a.*,connect_time,client_tcp_port,client_net_address from tb1 a inner join master.sys.dm_exec_connections b With(nolock) on a.session_id=b.session_id order by cpu_time desc
with tbas(select --blocking_session_id,session_id,db_name(database_id) as dbname,text from master.sys.dm_exec_requests a With(nolock)CROSS APPLY master.sys.dm_exec_sql_text(a.sql_handle))