sql performance Kill Lock
时间：2022-03-13 23:25
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
时间：2022-03-13 23:25
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
