Wednesday, March 7, 2012

Local SQL Server Connection times out during network outage

Hi,
we just upgraded to active directory from nt 4 domain.
In our HQ office we have 2 SQL servers for various
applications. We have a DNS/DC/GC server located at this
location and a DNS/DC/GC server located at a remote site.
During the last couple months after the upgrade we have
had a couple network outages. During these times sql
access to these local servers within the local office has
been so slow that it times out our applications and the
local users cannot use their local sql servers. Any
ideas on what is happening?
Sounds like the clients were trying to resolve the local server name in DNS
or WINS, that were unreachable perhaps. With SQL 2000 you can connect with
Shared Memory, which never needs to go out on the network. So, essentially
local connections are just that , local.
I would check to see if Shared Memory is enabled on the machine, and if
there were an local aliases used. If there is an alias specifying TCP for
example, then the client would attempt to use TCP, which could be a problem
under those conditions.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

No comments:

Post a Comment