The lock request time-out period has been exceeded. (Microsoft SQL Server, error: 1222)

When you operate the SQL Server database, you encounter a problem where the lock request time-out period has been exceeded. (Microsoft SQL Server, error: 1222)

After looking for material to know for resource preemption, as a deadlock, kill the process is OK, the specific operation is as follows:

Select SpId from  Master. sysprocesses where db_name (dbID) = ' database name ' and   spId <> @ @SpId and   DbID <> 0

The above statement is to get the process ID, the following is to kill the corresponding process by ID

EXEC (' Kill ' +spid (process ID))

The lock request time-out period has been exceeded. (Microsoft SQL Server, error: 1222)