Psst! Did you know DevelopmentNow is a mobile web site design agency?

Contact us for help mobilizing your site, or to sign up for our beta Mobile Web SDK!
all groups > sqlserver server > february 2006 >

sqlserver server : load balancing


JIM.H.
2/27/2006 7:11:27 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
2/28/2006 12:00:00 AM
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/


[quoted text, click to view]
AddThis Social Bookmark Button