Load balancing in SQL Server

We are doing a feasilibility study of using SQL Server cluster for load balancing.
Our clients will be running on Linux/Apache, connecting to SQL Server using JDBC.
Some c++ client tools will connect using ODBC.
Based on my limited knowledge of SQLServer clustering technology, it seems that
it does not have load balancing cluster with more than one node. In other
words, it will not allow connections to the same database from more than one
node. Only one node can own up the database, which to means that it will do
all the work pertaining to that database.
I also understand that if our goal is to balance the load amongst various nodes,
then Federated server is a better option. Can anyone explain this. Did I understand
it correctly.
I tried to find information about this in books online, but couldn't find it.
Were else can I get the information.
TIA.
SQL Server clustering is not for load balancing. It's for high
availability. Using federated servers is for load balancing. Check out
distributed partitioned views in the BOL.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"rkusenet" <rkusenet@.sympatico.ca> wrote in message
news:c49pju$2g12jc$1@.ID-75254.news.uni-berlin.de...
We are doing a feasilibility study of using SQL Server cluster for load
balancing.
Our clients will be running on Linux/Apache, connecting to SQL Server using
JDBC.
Some c++ client tools will connect using ODBC.
Based on my limited knowledge of SQLServer clustering technology, it seems
that
it does not have load balancing cluster with more than one node. In other
words, it will not allow connections to the same database from more than one
node. Only one node can own up the database, which to means that it will do
all the work pertaining to that database.
I also understand that if our goal is to balance the load amongst various
nodes,
then Federated server is a better option. Can anyone explain this. Did I
understand
it correctly.
I tried to find information about this in books online, but couldn't find
it.
Were else can I get the information.
TIA.