Load Balancing

Hi,
I need a solution to perform load balancing on my OLTP database, for example
between two servers.
Any help would be greatly appreciated,
Leila"Leila" <Leilas@.hotpop.com> wrote in message
news:O9er3Ei1EHA.3540@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I need a solution to perform load balancing on my OLTP database, for
> example
> between two servers.
> Any help would be greatly appreciated,
> Leila
>
SQL Server does not do load balancing automatically.
You should look at partitioning your data and using partitioned views to
build a pseudo-load balanced set of database tables.
Check out Partitioned Data in the BOL.
HTH
Rick Sawtell
MCT, MCSD, MCDBA