select --*

 request_session_id as spid,

 resource_type as restype,

 resource_database_id as dbid,

 DB_NAME(resource_database_id) as dbname,

 resource_description as res,

 resource_associated_entity_id as resid,

 case when resource_type= 'OBJECT' then OBJECT_NAME( resource_associated_entity_id )

 end

  as objectName,

 request_mode as mode,

 request_status as status

 from sys.dm_tran_locks

 select --*

 session_id as spid,

 connect_time,

 last_read,

 last_write,

 most_recent_sql_handle,

 text

 from sys.dm_exec_connections

 cross apply sys.dm_exec_sql_text(most_recent_sql_handle) --as a

 where session_id in (56,57)

 select --*

 session_id as spid,

 login_time,

 host_name,

 program_name,

 login_name,

 nt_user_name,

 last_request_start_time,

 last_request_end_time

 from sys.dm_exec_sessions

 where session_id in (56,57)

 select --*

 [session_id],

 [blocking_session_id],

 [command],

 [sql_handle],

 text,

 [database_id],

 [wait_type],

 [wait_time],

 [wait_resource]

 from sys.dm_exec_requests

 cross apply sys.dm_exec_sql_text([sql_handle])

 where blocking_session_id>0