两张表
select * from sys.dm_tran_active_transactions
select transaction_id,* from sys.dm_exec_requests
dm_tran_active_transactions表中有一个transaction_id和name
dm_exec_requests表中有一个transaction_id和command
command和name等同
set statistics profile on 这个是可以看执行计划