SQL Server has exceeded lock request timeout period 1222 error

Today in SSMs (Microsoft SQL Server Management Studio), click on the left side of the explorer to view the database corresponding to the table, you will encounter "Lock Request time out period exceeded." (Microsoft SQL Server, error 1222) ", the corresponding Chinese error prompt is" the lock request time-out period has been exceeded. (Microsoft SQL Server, Error: 1222) ".

This is caused by a deadlock, execute the following statement

SELECT *
From Master. sysprocesses
where db_name (DbID) = ' database name '
and spId <> @ @SpId
and DbID <> 0
>0; blocked

Get results:

spid	Kpid	Blocked
59	760	339
95	26224	285
225	27444	285
285	7248	339
318	-31804	285

This is because the 339 process causes a deadlock, which returns to normal after executing the statement kill 339.

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

SQL Server has exceeded lock request timeout period 1222 error