Connection timing out on some servers, not on others

Question

Connection timing out on some servers, not on others

Viewing 2 posts - 1 through 3 (of 3 total)

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

Steve Jones - SSC Editor SSC Guru Points: 739545 More actions · Answer 1

Is it running on the same client in both cases? If not, you have two choices, client or server potential issues.

You could have a different isolation level on each server or connection, which could cause the behavior. I'm not quite clear why you have blocking. Are you opening the connection from inside the transaction to read things?

Brian-538429 SSC Veteran Points: 244 More actions · Answer 2

Thanks for the response Steve. We got a call this morning and it emerged that 'we killed all other sessions' actually meant 'we killed all other sessions - except that one', which of course just happened to be a session running a process with a known bug. Oh well, problem fixed now anyway. Thanks for the help.