aanmelden
home web developer terminate sql server process

Terminate SQL Server Process

Laatst gewijzigd: zaterdag 17 maart 2018 om 7:33

Two ways to kill blocking process.

Activity Monitor

Open SSMS and connect to your instance. After you have connected, right click on the instance name and select 'Activity Monitor' from the menu.

Expand the ‘Processes’ section. Scroll down to the SPID of the process you would like to kill. Right click on that line and select ‘Kill Process’.

Kill Command

Open SSMS and connect to your instance. After you have connected, right click on the instance name and select ‘New Query’ from the menu.

Execute the following TSQL statements:

USE Master
GO
EXEC sp_who2
GO

Use this list of processes to confirm the SPID you wish to kill, then execute the following TSQL statement:

KILL {SPID}
GO