How to Check some table was locked

select * from sys.sysprocesses where blocked<>0

 看看waittime是不是很大 

kill spid