用友u9一些常用sql分享

--查看指定spid正在执行的SQL
select top 1 total_elapsed_time,substring(text,(statement_start_offset+2)/2, (case when statement_end_offset = -1   then (len(convert(nvarchar(MAX),text))*2)  else statement_end_offset  end - statement_start_offset) /2  ),a.* from sys.dm_exec_requests a cross apply sys.dm_exec_sql_text(sql_handle)
where a.session_id=78


--锁定与被锁定间的链状关系 
select t1.resource_type as [资源锁定类型]
    ,db_name(resource_database_id) as [数据库名]
    ,t1.resource_associated_entity_id as [锁定的对象]
    ,t1.request_mode as [等待者需求的锁定类型]
    ,t1.request_session_id as [等待者sid]  
    ,t2.wait_duration_ms as [等待时间]   
    ,(select text from sys.dm_exec_requests as r  
       cross apply sys.dm_exec_sql_text(r.sql_handle) 
       where r.session_id = t1.request_session_id) as [等待者要执行的批次]
    ,(select substring(qt.text,r.statement_start_offset/2+1, 
           (case