SELECT blocking_session_id '阻塞进程的ID'
, wait_duration_ms '等待时间(毫秒)'
, session_id '(会话ID)'
FROM sys.dm_os_waiting_tasks
select spId,status,lastwaittype,PROGRAM_NAME
from master..SysProcesses
where DB_NAME(dbId) = 'BI'
and spid <> @@SPID
and dbid <> 0
当你需要再次删表的时候,建议先truncate table ,然后再drop,这样速度快。提醒要注意做好备份工作,免得发生意外,比如删错表名类似的表。
---查看表被锁住的情况
SELECT request_session_id spid,OBJECT_NAME
(resource_associated_entity_id)tableName
FROM sys.dm_tran_locks
WHERE resource_type='OBJECT';