why sp_who2 shows the query status as sleeping ,eventhough it has been running

Question

There is a delete query that has been running for an hour.

Just fired sp_who2 and it shows the status of the query as sleeping, even though it is running. Why sp_who2 shows the query status as sleeping?

Could you describe the problem three times identically? Seriously, why have you written the question like this? — Damien_The_Unbeliever, Aug 27 '13 at 14:40

score 3 · Answer 1 · answered Aug 27 '13 at 15:27

3

you can try with:

dbcc inputbuffer(@Spid)

take the SPID with the sp_who2 and see exactly what the is running for that user.

answered Aug 27 '13 at 15:27

FpontoDesenv

162
1
13

score 2 · Accepted Answer · answered Aug 27 '13 at 14:31

2

A process is considered sleeping occasionally when its waits for some resources or being blocked by some other process.

answered Aug 27 '13 at 14:31

Sonam

3,406
1
12
24

I am also facing same issue, Please suggest me, what could be the issue, Have a look on attached link - https://stackoverflow.com/questions/71156721/pyodbc-connection-going-to-sleep-mode – Suneel Kumar Feb 19 '22 at 12:09

why sp_who2 shows the query status as sleeping ,eventhough it has been running

2 Answers2