Hi

I have 2 SQL servers (Active/Active) with a SAN.

I see to get a very long connection delay when connection to the second
instance from a webserver this can be upto 3 seconds.

Each Instance is active on the opersite server and the second instance is
running on port 1434.

Does anyone know what the problem could be?

Andy

You can run some tests/monitors to figure out where exactly it's being held
back but right off the bat, use a different port. SQL Server 2000 uses 1434
(UDP) for discovery by default. Setting your second instance to listen on
that port raises issues with security and performance that you probably
don't want to get into. Unless you have really strong reasons to stick with
it, I suggest you use another port.

joe.


"Andrew Gilbert" <AndrewGilbert (AT) discussions (DOT) microsoft.com> wrote

Hi

How are you connecting?

servername\instancename
servername\instancename, portnumber
etc?

Defining a port number may speed things up, but then you need to configure
the instance to use a static port though "Server Network Utility"

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike (AT) epprecht (DOT) net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"Andrew Gilbert" <AndrewGilbert (AT) discussions (DOT) microsoft.com> wrote