Groups > comp.databases.ms-sqlserver > #1550

Re: pitfalls of accessing linked server over WAN

X-Received	by 10.224.4.138 with SMTP id 10mr12099882qar.8.1377155403767; Thu, 22 Aug 2013 00:10:03 -0700 (PDT)
X-Received	by 10.49.70.170 with SMTP id n10mr338qeu.22.1377155402749; Thu, 22 Aug 2013 00:10:02 -0700 (PDT)
Path	csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!news.glorb.com!fx3no3960455qab.0!news-out.google.com!c19ni456qak.0!nntp.google.com!fx3no3960452qab.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups	comp.databases.ms-sqlserver
Date	Thu, 22 Aug 2013 00:10:02 -0700 (PDT)
In-Reply-To	<kv4c54$vn0$1@news.albasani.net>
Complaints-To	groups-abuse@google.com
Injection-Info	glegroupsg2000goo.googlegroups.com; posting-host=87.222.81.20; posting-account=jIl9nQoAAAA9P37IIqQq64yAx-2NQYiu
NNTP-Posting-Host	87.222.81.20
References	<1c953ac5-0c12-4cfe-9c43-b688af51846e@googlegroups.com> <kv1rsh$89l$1@news.albasani.net> <9f11ffde-7f43-410c-b1d2-978b118aa415@googlegroups.com> <kv4c54$vn0$1@news.albasani.net>
User-Agent	G2/1.0
MIME-Version	1.0
Message-ID	<065e38ee-941d-4d7f-9f82-28efd2a4d499@googlegroups.com> (permalink)
Subject	Re: pitfalls of accessing linked server over WAN
From	bradbury9 <ray.bradbury9@gmail.com>
Injection-Date	Thu, 22 Aug 2013 07:10:03 +0000
Content-Type	text/plain; charset=ISO-8859-1
Content-Transfer-Encoding	quoted-printable
Xref	csiph.com comp.databases.ms-sqlserver:1550

Show key headers only | View raw

El jueves, 22 de agosto de 2013 08:47:05 UTC+2, Lutz  escribió:
> > I tried it against a linked server while the remote box was down to simulate WAN down situation and it takes 50 sec to come back with messages
> 
> >
> 
> > OLE DB provider "SQLNCLI10" for linked server "REMOTEBOX" returned message "Login timeout expired".
> 
> > etc...
> 
> >
> 
> > That long wait is not acceptable for application, I'd like to know if we can possibly decrease that 50 seconds to 5 seconds, in our environment it is reasonable to conclude that link is down if connection is not obtained within 5 sec.
> 
> >
> 
> > I tried
> 
> > EXEC master.dbo.sp_serveroption @server=N'REMOTEBOX', @optname=N'connect timeout', @optvalue=N'5'
> 
> > EXEC master.dbo.sp_serveroption @server=N'REMOTEBOX', @optname=N'query timeout', @optvalue=N'5'
> 
> >
> 
> > but that had no effect on the long wait time for login.
> 
> >
> 
> > Are there any ways to do what I am trying to achieve?
> 
> >
> 
> 
> 
> Maybe this is your problem ...
> 
> 
> 
> http://social.msdn.microsoft.com/Forums/sqlserver/en-US/ec917a47-0478-4d1b-8425-958a7f33effe/syssptestlinkedserver
> 
> 
> 
> "Unfortunately there is no way to control this. When you give a 
> 
> non-existant server name, SQL Server is trying to resolve the name of 
> 
> the server using Windows API - this means that depending on the network 
> 
> protocols and your network topology it can take several minutes. For 
> 
> example, DNS name resolution is more than 1 1/2 minutes.
> 
> 
> 
> Btw, you can use Windows Registry tweaks to control some of the timeout 
> 
> values. Search MSKB for more details."
> 
> 
> 
> Can you try it with IP instead of server name?

or manually put a line in hosts file to avoid DNS resolution without changing application setup, that file in windows is in [Windows_folder]\System32\drivers\etc\hosts and in linux /etc/hosts

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

pitfalls of accessing linked server over WAN migurus <migurus@yahoo.com> - 2013-08-20 18:31 -0700
  Re: pitfalls of accessing linked server over WAN Erland Sommarskog <esquel@sommarskog.se> - 2013-08-21 07:20 +0000
    Re: pitfalls of accessing linked server over WAN migurus <migurus@yahoo.com> - 2013-08-21 17:24 -0700
      Re: pitfalls of accessing linked server over WAN Erland Sommarskog <esquel@sommarskog.se> - 2013-08-22 08:48 +0000
  Re: pitfalls of accessing linked server over WAN Lutz <news@invalid.invalid> - 2013-08-21 10:02 +0200
    Re: pitfalls of accessing linked server over WAN migurus <migurus@yahoo.com> - 2013-08-21 17:21 -0700
      Re: pitfalls of accessing linked server over WAN Lutz <news@invalid.invalid> - 2013-08-22 08:47 +0200
        Re: pitfalls of accessing linked server over WAN bradbury9 <ray.bradbury9@gmail.com> - 2013-08-22 00:10 -0700
        Re: pitfalls of accessing linked server over WAN migurus <migurus@yahoo.com> - 2013-08-22 11:32 -0700

csiph-web