Tags » Spid

MS SQL - find and kill session

You can use the following query to check online session and kill:


Kill command with spid:

kill <spid>

Another way to clean up old sessions – find all session which is idle more than 60 minutes: 104 more words


What is SPID in SQL Server?

A SPID in SQL Server is a Server Process ID. These process ID’s are essentially sessions in SQL Server. Every time an application connects to SQL Server, a new connection (or SPID) is created. 288 more words