SQL 事务隔离学习

 1 select --* 
 2 request_session_id as spid,
 3 resource_type as restype,
 4 resource_database_id as dbid,
 5 DB_NAME(resource_database_id) as dbname,
 6 resource_description as res,
 7 resource_associated_entity_id as resid,
 8 case when resource_type= ‘OBJECT‘ then OBJECT_NAME( resource_associated_entity_id )
 9 end 
10  as objectName,
11 request_mode as mode,
12 request_status as status
13 from sys.dm_tran_locks
14 
15 
16 select --* 
17 session_id as spid,
18 connect_time,
19 last_read,
20 last_write,
21 most_recent_sql_handle,
22 text
23 from sys.dm_exec_connections
24 cross apply sys.dm_exec_sql_text(most_recent_sql_handle) --as a
25 where session_id in (56,57)
26 
27 select --*
28 session_id as spid,
29 login_time,
30 host_name,
31 program_name,
32 login_name,
33 nt_user_name,
34 last_request_start_time,
35 last_request_end_time
36 from sys.dm_exec_sessions
37 where session_id in (56,57)
38 
39 select --*
40 [session_id],
41 [blocking_session_id],
42 [command],
43 [sql_handle],
44 text,
45 [database_id],
46 [wait_type],
47 [wait_time],
48 [wait_resource]
49 from sys.dm_exec_requests
50 cross apply sys.dm_exec_sql_text([sql_handle])
51 where blocking_session_id>0