Tags » Spid

Troubleshooting SQL-Based Software

The company where I currently work produces a software solution that relies on SQL databases to store its information.  A lot of the issues I encounter on a daily basis have to do with performance: how come a certain module is taking so long to open or why is a certain procedure running long? 1,344 more words

AdventureWorks

MS SQL - find and kill session

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

sp_who

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

Database

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

SPID