Stack Overflow
Stack Overflow

Questions tagged [spid]

A Server Process ID for MS SQL Server or Sybase ASE

MS SQL Server and Sybase ASE use SPID to refer to a Server Process ID -- essentially a session with a defined scope and memory space.

The term SPID is also used in telecommunications for Service Profile Identifier.

27 questions
17
votes
4 answers

SQL Server - Hanging Process - SPID Query

How do I find what is the associated query that is being executed if I have the SPID. Trying to figure out what query is being associated since the process seems to be hung.
Chris
  • 2,923
  • 6
  • 26
  • 25
11
votes
2 answers

SQL Server: how do I kill a -3 SPID?

There's plenty of information about positive SPIDs and even -1 and -2 but I haven't found any information on Blocked By -3. Would anyone be able to help? GUID is all 0's, and when I run sp_who2 on MASTER db it shows a SPID of 56 as RUNNABLE on the…
plankton
  • 369
  • 5
  • 21
6
votes
1 answer

What is the relationship between a SPID and a Connection in SQL server?

Can a SPID be used by two connections, while both connections are open? If a connection is returned to a connection pool, will it hold on to the SPID?
Shiraz Bhaiji
  • 64,065
  • 34
  • 143
  • 252
5
votes
2 answers

Process/SPID is being blocked by itself, how to clear/kill without restarting Sql Server

We have a process that was running for 4 hours. Because it was running so long, it was causing other issues in the database, so it was decided to kill the process. Now, the process is in a suspended state. It also states that it's being blocked by…
ganders
  • 7,285
  • 17
  • 66
  • 114
4
votes
1 answer

What is the relationship between open SqlConnections in the client app and processes in SQL Server?

I just tried to make a simple schema change to a table in a SQL Server database (by using the Design tool in SMSS). Whenever I tried to save the change, it kept timing out. I wondered whether this was due to existing connnections which were…
David
  • 15,750
  • 22
  • 90
  • 150
3
votes
6 answers

Identifying underlying sql connection of SqlConnection object

I can use GetHashCode() to identify an object but is there any way to identify the actual sql connection obtained by a SqlConnection object? I'm (still) trying to debug a problem involving pooled connections and application roles and if I could…
Ed Guiness
  • 34,602
  • 16
  • 110
  • 145
2
votes
2 answers

How do I kill an unruly spid in Sybase?

I've got a couple of rogue spid's in my database that I can see are sleeping when I log in as sa and use sp_who, but attempts to use kill to eliminate them have failed and I don't actually have access to the server itself to bounce it. Is…
ninesided
  • 23,085
  • 14
  • 83
  • 107
2
votes
1 answer

SQL Server Query Time Out

A 3rd party application accessing a SQL Server 2012 database is getting [Microsoft][ODBC SQL Server Driver]Query timeout expired errors after executing for about 20 mins. This is what I see on the database after the application starts receiving the…
slayernoah
  • 4,382
  • 11
  • 42
  • 73
1
vote
0 answers

Different SPID in Status Bar than @@SPID

Today I ran into something I haven't seen before. I think it's actually a bug, but I figured I'd ask if anyone else has seen this before. The SPID displayed in the status bar of one of my query windows doesn't match the result of SELECT @@SPID…
JoZ
  • 31
  • 5
1
vote
0 answers

Is it possible situation: SQL Server use the same spid for two instances of same application?

There are an application and SQL Server which communicate with each other. A user runs two instances of the application in the computer. He starts execution of one operation in the first instance, and then starts execution of another operation in…
Slava Podolskiy
  • 155
  • 1
  • 11
1
vote
2 answers

SQL Server Log - Souce (SPID)

In checking Log File Viewer for noteworthy events I came across a log that I wanted to investigate. Let's say the log notes the Source as SPID1234 My question: Is this SPID tied to the actual connection that generated the log or is the SPID…
Marcus Neilson
  • 25
  • 2
  • 5
1
vote
1 answer

sys sysprocesses in sql server list kpid 4056 but kpid not exist in server process

i am runnig query from sys.sysprocesses one of the results is process with kpid '4056' and SPId 390 but when i saw the windows task manager or tasklist from command prompt 1-i tried to kill this process with kill 390 in sql server:it doesnt kill and…
abianari
  • 343
  • 7
  • 19
1
vote
2 answers

Getting the spid of a Powerbuilder database Connection?

I've been trying to find some manual information on this, but my search is fruitless. I'm trying to see if there is a way to find the unique spid (from sp_who) of a connection into a database from Powerbuilder. As in, a user logs in, and I can see…
glasnt
  • 2,865
  • 5
  • 35
  • 55
0
votes
1 answer

Transport-level error: SQL Server lost connection (forcibly closed by remote host) after windows sleep mode

I built a VB .NET app which has a connection to SQL Server. While the app is running, the Windows OS changes to sleep mode. After I turn the machine on again, I found this error: A transport-level error has occurred when sending the request to the…
David Rozando
  • 92
  • 1
  • 11
0
votes
0 answers

Python bot that logs in using SPID

Hi guys I have a question. In the university where I study, before going to the library it is necessary to reserve a seat through a website or on the website app. There are often a lot of people, so there are no seats available. For this reason, I…
Zeld
  • 33
  • 6
1
2