Query window

Question

Post reply

Query window

Mike Levan

SSChampion

Points: 14201
More actions
February 12, 2009 at 2:31 pm

#128144

My query window disconnects by itself all the time when i am running long queries.
I create multiple temp tables once for abt 3 hrs and then select all the data from those tables as next step but suddenly i gets diconnected.
what might be the reason.
thanks

Viewing 9 posts - 1 through 8 (of 8 total)

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

Mike Levan SSChampion Points: 14201 More actions · Answer 1

is there any clue why i get disconnectyed all of a sudden. and i get this error mesg

"A transport-level error has occurred when sending the request to the server"

mazzz SSCertifiable Points: 6139 More actions · Answer 2

That error message usually means the network's gone wobbly when we get it where I work

------------------------------------------------------------------------
Bite-sized fiction (with added teeth) [/url]

Mike Levan SSChampion Points: 14201 More actions · Answer 3

This happens every day to the developers , not sure why?

where the problem might be? is it related to sql server or network problem

Roy Ernest SSC-Dedicated Points: 38780 More actions · Answer 4

Could be a badly configured switch that is creating a storm. It even could be one badly configured network card... This is basically a network issue.

-Roy

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 5

Mike Levan (2/13/2009)
is there any clue why i get disconnectyed all of a sudden. and i get this error mesg
"A transport-level error has occurred when sending the request to the server"

I've seen this message before, with intermittent network outages.

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

Mike Levan SSChampion Points: 14201 More actions · Answer 6

what is the work around for this so the it never happens again.

Roy Ernest SSC-Dedicated Points: 38780 More actions · Answer 7

If it is a network issue, there is no work around I am afraid. You will have to get the Techs or Network Admins to find out where the problem is and then fix it.

-Roy

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 8

Mike Levan (2/13/2009)
what is the work around for this so the it never happens again.

B****slap your network engineer, tell them not to let it happen again or there will be an employment outage.

Seriously though Mike, this kind of thing is demoralising to staff and costs the company money. You're the database guy, not the network guy, and he's compromising your ability to deliver. Escalate it tactfully but without pulling punches either.

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden