Hi,

I seem to understand the terminology of failover clustering as well as the
sibgle/mulple instance installations but it seems it does take about 2min for
a node to take over etc. I also red about log shipping and transactional
replication... Is there a way to load balance that can be done with SQL since
NLB was designed not for sql/exchange but for other netwrking services as ftp
etc?

Thanks
--
George

First, lets address your failover time. 2 minutes for a server under load
is not out of the ordinary, especially if you have either a lot of load or
AWE memory on your server. Here is one possible explanation:

http://support.microsoft.com/default...b;en-us;329914

The problem with SQL load balancing isn't the network layer, NLB and other
commercial solutions handle that just fine. The problem is in synchronizing
the transactions. If you can partition your data, you can scale out. IF
the data is read-only, you can scale out. If you need single transactional
store, you must scale up.

Geoff N. Hiten
Microsoft SQL Server MVP


"George" <George (AT) discussions (DOT) microsoft.com> wrote