SQL Server 监控锁定信息

查看当前数据库锁定信息:

declare   @tba  TABLE
(spid  int,dbid INT,objectid INT,
indld INT,TYPE VARCHAR(20),resource VARCHAR(50),mode VARCHAR(20),status VARCHAR(10))
insert  into @tba exec sp_lock 
select spid,OBJECT_name(objectid) tab,TYPE,resource,mode,status from @tba WHERE dbid=DB_ID()
and OBJECT_name(objectid)<>''
ORDER BY 2