MS SQL Server - load balancing

Author

load balancing

JIM.H.

2006-02-28, 8:23 pm

Hello,

How is load balancing working in SQL Server 2000. We want to have two
different servers as a back end for our web based eCommerce application. Is
this possible? While there be any modification requirement in the application?

Tibor Karaszi

2006-02-28, 8:23 pm

There's no transparent load balancing in SQL Server. There are options to spread load over several
servers, each has advantages and disadvantages. Things you might want to read about in Books Online:

Distributed partitioned views (aka federated servers)
Replication

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
Blog: http:// solidqualitylearning
.com/blogs/tibor/

"JIM.H." <JIMH@discussions.microsoft.com> wrote in message
news:946586F9-803E-4248-AA8E- 576A144A21FD@microso
ft.com...
> Hello,
>
> How is load balancing working in SQL Server 2000. We want to have two
> different servers as a back end for our web based eCommerce application. Is
> this possible? While there be any modification requirement in the application?
>

Sponsored Links