SqlServer 查看当前锁请求脚本

sp_lock

select resource_type,resource_description,request_mode,request_status,request_type,request_lifetime  
from sys.dm_tran_locks where resource_database_id=DB_ID() and request_session_id<>@@SPID 


select resource_database_id,resource_type,t2.waittype,t2.lastwaittype,t2.dbid,t2.hostname,t2.program_name,t2.cmd,t2.loginame,t2.net_library,t3.text
from sys.dm_tran_locks
inner join sys.sysprocesses t2 on request_session_id = t2.spid
cross apply sys.dm_exec_sql_text(t2.sql_handle) t3
where resource_type<>'DATABASE' and request_session_id<>@@SPID


select req_spid,case req_status when 1 then '已授予' when 2 then '正在转换' when 3 then '正在等待' end as req_status,case rsc_type when 1 then 'NULL 资源（未使用）' when 2 then '数据库' when 3 then '文件'
	when 4 then '索引' when 5 then '表' when 6 then '页' when 7 then '键' 
	when 8 then '扩展盘区' when 9 then 'RID（行 ID)' when 10 then '应用程序' else '' end rsc_type,coalesce(OBJECT_NAME(rsc_objid),db_name(rsc_dbid)) as [object],case req_mode when 1 then 'NULL' when 1 then 'Sch-S' when 2 then 'Sch-M' when 3 then 'S' 
	when 4 then 'U' when 5 then 'X' when 6 then 'IS' when 7 then 'IU' when 8 then 'IX' when 9 then 'SIU' 
	when 10 then 'SIX' when 11 then 'UIX' when 12 then 'BU' when 13 then 'RangeS_S' when 14 then 'RangeS_U' 
	when 15 then 'RangeI_N' when 16 then 'RangeI_S' when 17 then 'RangeI_U' when 18 then 'RangeI_X'	
	when 19 then 'RangeX_S' when 20 then 'RangeX_U' when 21 then 'RangeX_X' else '' end req_mode,rsc_indid as index_id,rsc_text,req_refcnt,case req_ownertype when 1 then '事务' when 2 then '游标' when 3 then '会话' when 4 then 'ExSession' else'' end req_ownertype
from sys.syslockinfo WHERE rsc_type<>2

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!