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,resource_description,request_mode,request_status,request_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
SqlServer 查看当前锁请求脚本
最新推荐文章于 2023-07-14 16:08:34 发布