/* 查看锁信息 */select l.resource_type ,l.resource_associated_entity_id ,OBJECT_NAME(sp.OBJECT_ID) AS objectName ,l.request_status,l.request_mode,request_session_id ,l.resource_description FROM sys.dm_tran_locks l LEFT JOIN sys.partitions sp ON sp.hobt_id = l.resource_associated_entity_id WHERE l.resource_database_id = DB_ID()
[/align]
我的sql一般啊,能否告诉我怎么查?
/*
查看锁信息
*/select l.resource_type ,l.resource_associated_entity_id
,OBJECT_NAME(sp.OBJECT_ID) AS objectName
,l.request_status,l.request_mode,request_session_id
,l.resource_description
FROM sys.dm_tran_locks l
LEFT JOIN sys.partitions sp
ON sp.hobt_id = l.resource_associated_entity_id
WHERE l.resource_database_id = DB_ID()
sp_who2看看
kill