The lock request timeout period has been exceeded. (Microsoft SQL Server, error: 1222), sql1222

The lock request timeout period has been exceeded. (Microsoft SQL Server, error: 1222), sql1222

When operating the SQL Server database, the following problem occurs: the lock request timeout period has been exceeded. (Microsoft SQL Server, error: 1222)

After finding the materials, we can see that the resources are preemptible and the process is killed as a deadlock. The specific operations are 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, and the following is to kill the corresponding process according to the ID

Exec ('Kill '+ spId (process ID ))