load balancing & sql ?

can you use load balancing with a server running SQL server 2000 standard
edition ?
i.e is traffic balanced correctly ?
(sorry if its a silly question - i just need to be sure).
ScottIn the context of SQL Server, the question just doesn't make sense.
What are you 'load balancing'?
Load balancing is normally intended to direct traffic to one of multiple
servers -typically web servers. I would think that having a database in
multiple servers would create problems with data consistency, etc.
Perhaps if you told us a little more about what you are attempting to
accomplish, we can help direct you to the correct information.
Arnie Rowland
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"scott" <aintnowspamhere@.yahoo.com> wrote in message
news:ePoYZryrGHA.4884@.TK2MSFTNGP03.phx.gbl...
> can you use load balancing with a server running SQL server 2000 standard
> edition ?
> i.e is traffic balanced correctly ?
> (sorry if its a silly question - i just need to be sure).
> Scott
>|||thanks for reply.
I should have explained more sorry. I simply meant in the context of two
gigabit network cards in a server running sbs 2003 and sql standard edition
for 30 users.
Scott|||scott wrote:
> thanks for reply.
> I should have explained more sorry. I simply meant in the context of two
> gigabit network cards in a server running sbs 2003 and sql standard editio
n
> for 30 users.
> Scott
>
>
There shouldn't be any problems in having 2 network cards in the server,
but I doubt it will make any difference. In terms of load and
performance, it's in my opinion never the network cards that causes any
bottleneck. It's your disk system and your CPU/Memory that affects
performance.
Regards
Steen Schlter Persson
Databaseadministrator / Systemadministrator|||...and bad SQL(locking/blocking) :-)
"Steen Persson (DK)" wrote:

> scott wrote:
> There shouldn't be any problems in having 2 network cards in the server,
> but I doubt it will make any difference. In terms of load and
> performance, it's in my opinion never the network cards that causes any
> bottleneck. It's your disk system and your CPU/Memory that affects
> performance.
>
> --
> Regards
> Steen Schlüter Persson
> Databaseadministrator / Systemadministrator
>|||I can't imagine that you have a server for 30 users where a single GB NIC
will be 'overloaded', so the second one is mostly providing a 'safety net'.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"scott" <aintnowspamhere@.yahoo.com> wrote in message
news:%23N1GXG8rGHA.4004@.TK2MSFTNGP02.phx.gbl...
> thanks for reply.
> I should have explained more sorry. I simply meant in the context of two
> gigabit network cards in a server running sbs 2003 and sql standard
> edition for 30 users.
> Scott
>|||excellent thanks for the replies
Scott