SQL Server process deadlock shutdown method _mssql

1. First we need to determine which user is locked in which table.

--Query Locked table
Select request_session_id spid,object_name (resource_associated_entity_id) tablename 

A table that contains the SPID and tablename columns is returned after the query.

Where the SPID is the process name and TableName is the table name.

2. Knowing which process has locked the table, you need to find the host that locked the table through the process.

--Query host name
exec sp_who2 ' xxx ' 
xxx is the process of the SPID column, the retrieval will list a lot of information, which contains the host name.

3. The shutdown process is performed through the value of the SPID column.

--Close process
declare @spid int 
Set @spid = xxx-Lock table process
declare @sql varchar (1000)
set @sql = ' Kill ' +cast (@ SPID as varchar)

PS: Sometimes it is dangerous to force a process to kill, so it is best to find the host that executes the process and shut down the process on that machine.

The above is a small set to introduce the SQL Server process deadlock closed method, I hope to help you, if you have any questions please give me a message, small series will promptly reply to everyone. Here also thank you very much for the cloud Habitat Community website support!