sp_who2 active
sp_lock 76
select object_name(261575970,16)
select %%lockres%%,* from SessionLock(nolock) --from reporttempdb
select * from SessionData where SessionID=‘scaszk45rrhlqureb1pvbp45‘
kill 71
sql performance Kill Lock
原文：http://www.cnblogs.com/hqbird/p/3956639.html
