Load Balancing

Hi,
In windows 2003 server you have NLB (Network Load Balancing).
Can i use this to load balance my traffic to our sql server?
I know you also have "Microsoft Cluster Service" but that's only available
with Windows Server 2003 Enterprise Edition.
So is it possible to load balance my traffic from our webservers to our sql
servers?
And i will create a replication on the background between the 2 sql servers
so they will both serve the same data.
I hope someone has an answer for me.
Thanks in advance.
FlorisLoad balancing when you own data (like a DBMS does) and you also want to mod
ify that data is far
from trivial.
I don't think any system does that transparently (you either use shared disk
, where you till only
have one copy of data or you do shared nothing where you only have a set of
data on one location).
First determine what modifications are to be performed. Easiest is of you ca
n separate read-only
applications (reports etc). If so, you can replicate (using built-in transac
tional replication) from
the server where you do modifications to the read-only server.
If you cannot separate read-only applications, you can look into merge repli
cation. However, if you
modify the same data at the same time on two nodes, one will win and the oth
er modification will be
lost. Unacceptable in many scenarios.
I suggest you read up in Books Online about Replication (there are different
types of replications)
as well as "federated servers" (also known as distributed partitioned views)
.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Floris" <meNOSPAM@.here_my_place.nl> wrote in message news:eEpmKVSjFHA.2472@.TK2MSFTNGP15.phx
.gbl...
> Hi,
> In windows 2003 server you have NLB (Network Load Balancing).
> Can i use this to load balance my traffic to our sql server?
> I know you also have "Microsoft Cluster Service" but that's only available
with Windows Server
> 2003 Enterprise Edition.
> So is it possible to load balance my traffic from our webservers to our sq
l servers?
> And i will create a replication on the background between the 2 sql server
s so they will both
> serve the same data.
> I hope someone has an answer for me.
> Thanks in advance.
> Floris
>|||Thanks!
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uMficaSjFHA.2180@.TK2MSFTNGP15.phx.gbl...
> Load balancing when you own data (like a DBMS does) and you also want to
> modify that data is far from trivial.
> I don't think any system does that transparently (you either use shared
> disk, where you till only have one copy of data or you do shared nothing
> where you only have a set of data on one location).
> First determine what modifications are to be performed. Easiest is of you
> can separate read-only applications (reports etc). If so, you can
> replicate (using built-in transactional replication) from the server where
> you do modifications to the read-only server.
> If you cannot separate read-only applications, you can look into merge
> replication. However, if you modify the same data at the same time on two
> nodes, one will win and the other modification will be lost. Unacceptable
> in many scenarios.
> I suggest you read up in Books Online about Replication (there are
> different types of replications) as well as "federated servers" (also
> known as distributed partitioned views).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Floris" <meNOSPAM@.here_my_place.nl> wrote in message
> news:eEpmKVSjFHA.2472@.TK2MSFTNGP15.phx.gbl...
>