Re: Newb question regarding cluster load balancing

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Thanks Geoff for the information. I thought as much but hoped otherwise.


"Geoff N. Hiten" <SQLCraftsman@xxxxxxxxx> wrote in message
news:e9dbmVrGGHA.3856@xxxxxxxxxxxxxxxxxxxxxxx
> You can install multiple instances of SQL Server on a failover cluster.
> You cannot natively load-balance the workload between these multiple
> instances. They act as independent SQL servers. SQL Clustering is a
> failover technology and does not natively load balance.
>
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "Michael Weyant" <mweyant@xxxxxxxxxxxxxxxxxxxx> wrote in message
> news:OshvlPrGGHA.312@xxxxxxxxxxxxxxxxxxxxxxx
>> Hello to all,
>>
>> I am currently working on creating a Windows 2003 server cluster (3
>> nodes) with the intent that it serve our web app which requires multiple
>> SQL databases. The question I have is this: How can I configure load
>> balancing for this? It seems that clustering services only allows 1 of
>> the nodes to access the DB at any given time (which is logical). If this
>> is true, how will I be able to leverage the processing power of the other
>> two nodes if they are idle while the node that is hosting the DB does all
>> the work?
>>
>> Any help would be appreciated.
>>
>> Michael
>>
>
>


.

Relevant Pages

  • Re: Veritas storage foundation HA for windows
    ... This is a solution to manage your data, not the services like SQL Server. ... To make an application cluster suitable ("cluster aware" is for used for ... Most of the time that we have hardware failure, ... Hope you have multiple generators, multiple UPS's, multiple switches, ...
    (microsoft.public.sqlserver.clustering)
  • Re: recovering from a clustered node failure
    ... Failover Cluster' for Recovering from Failover Cluster Failure. ... uninstalled, you can then install SQL on the replacement node. ... I support the Professional Association for SQL Server ...
    (microsoft.public.sqlserver.server)
  • Re: using sql cluster
    ... Today i have 2 diffrent sql servers of 2 diffrent databases. ... server to use sql server failover cluster. ... You can have a single cluster with several nodes. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Cluster active/active SQLServer/SSAS
    ... It appears that you are trying to configure a multiple instance SQL Server ... failover cluster. ... and a private network for the cluster heartbeat communications. ... You will then need to first install Windows Clustering ...
    (microsoft.public.sqlserver.clustering)
  • RE: active/passive cluster upg
    ... First I un cluster ... >Refer to the following articles in SQL Server 2000 Books ... >How to upgrade from a SQL Server 7.0 active/passive ... failover cluster ...
    (microsoft.public.sqlserver.clustering)