Connection went to suspended in sql server 2005

Question

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

RTaylor2208 SSChampion Points: 13298 More actions · Answer 1

I am pretty sure that indicates that the client app is not dropping the connetion once the request has completed.

You need to make sure that the client code opens a connection, does what is needs to do, then drops the connection once complete.

MCITP SQL 2005, MCSA SQL 2012

Mr. Holio Hall of Fame Points: 3314 More actions · Answer 2

What does the below query return?

SELECT wait_type, wait_time, last_wait_type

FROM sys.dm_exec_requests

WHERE session_id = 123

__________________________
Allzu viel ist ungesund...

Yuri55 SSCrazy Eights Points: 8449 More actions · Answer 3

It's rather Process (not Connection) has status "Suspended"

(as per BOL: "The session is waiting for an event, such as I/O, to complete").

You should analyze (as it was suggested) sys.dm_exec_requests (and sys.dm_os_tasks) outputs

for this session ID to find the reason for the waiting.

@SQLFRNDZ SSCrazy Eights Points: 9095 More actions · Answer 4

Status of SPID,

Suspended- Waiting on some resources or thread or on another query to complete.

Use this query to find what it is waiting on along with wait_type.[/url]

[font="Tahoma"]
--SQLFRNDZ[/url]
[/font]

solomon.jernas Hall of Fame Points: 3680 More actions · Answer 5

Hall of Fame

Points: 3680

September 29, 2011 at 9:56 pm

Thank you for information...