SqlServer死锁

报错信息：Lock request time out period exceeded. (Microsoft SQL Server，错误: 1222)

--查询数据库是否存在锁定的操作

select *

  from master..SysProcesses

 where db_Name(dbID) = 'studio_approach_prd'

   and spId <> @@SpId

   and dbID <> 0

   and blocked >0;

 

查询后恢复正常，以后出现死锁可参考

https://www.cnblogs.com/happyhippy/archive/2008/11/14/1333922.html