"Leila" <Leilas@hotpop.com> wrote in message
news:e14c5u2ZGHA.440@TK2MSFTNGP05.phx.gbl...
> Hi,
> Are there any solution to implement load balancing on one database between
> two nodes of cluster?
> Thanks in advance,
> Leila
>
>

"Leila" <Leilas@hotpop.com> wrote in message
news:e14c5u2ZGHA.440@TK2MSFTNGP05.phx.gbl...
> Hi,
> Are there any solution to implement load balancing on one database between
> two nodes of cluster?
> Thanks in advance,
> Leila
>
>

"Leila" <Leilas@hotpop.com> wrote in message
news:OLML$S9ZGHA.4784@TK2MSFTNGP02.phx.gbl...
> Hi Rodney,
>
>> ... and cluster the SQL backend...
> You mean a failover cluster?
>
>
>
> "Rodney R. Fournier [MVP]" <rod@die.spam.die.nw-america.com> wrote in
> message news:esZe458ZGHA.3736@TK2MSFTNGP04.phx.gbl...
>> If you have a web application you can load balance the web servers and
>> cluster the SQL backend.
>>
>> Cheers,
>>
>> Rodney R. Fournier
>>
>> MVP - Windows Server - Clustering
>> http://www.nw-america.com - Clustering Website
>> http://msmvps.com/clustering - Blog
>> http://www.clusterhelp.com - Cluster Training
>> ClusterHelp.com is a Microsoft Certified Gold Partner
>>
>>
>> "Leila" <Leilas@hotpop.com> wrote in message
>> news:e14c5u2ZGHA.440@TK2MSFTNGP05.phx.gbl...
>>> Hi,
>>> Are there any solution to implement load balancing on one database
>>> between two nodes of cluster?
>>> Thanks in advance,
>>> Leila
>>>
>>>
>>
>>
>
>

> ... and cluster the SQL backend...

> If you have a web application you can load balance the web servers and
> cluster the SQL backend.
>
> Cheers,
>
> Rodney R. Fournier
>
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering Website
> http://msmvps.com/clustering - Blog
> http://www.clusterhelp.com - Cluster Training
> ClusterHelp.com is a Microsoft Certified Gold Partner
>
>
> "Leila" <Leilas@hotpop.com> wrote in message
> news:e14c5u2ZGHA.440@TK2MSFTNGP05.phx.gbl...
>> Hi,
>> Are there any solution to implement load balancing on one database
>> between two nodes of cluster?
>> Thanks in advance,
>> Leila
>>
>>
>
>

> There is no native Microsoft SQL load balancing tool for clusters.
> Microsoft SQL clustering is an availability solution only and has no
> scale-out benefit.
>
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
>
>
> "Leila" <Leilas@hotpop.com> wrote in message
> news:e14c5u2ZGHA.440@TK2MSFTNGP05.phx.gbl...
>> Hi,
>> Are there any solution to implement load balancing on one database
>> between two nodes of cluster?
>> Thanks in advance,
>> Leila
>>
>>
>
>

"Nils Loeber" <nils@NOSPAMFORMEPLEASEnils-loeber.de> wrote in message
news:%23yydGxQaGHA.3992@TK2MSFTNGP05.phx.gbl...
> While this is true, you could implement a scenario using n instances on n
> nodes with distributed partitioned views. That means you horizontally
> split up a database table and distribute the parts on different instances
> which you switch to different nodes. You virtually join the table
> partitions by a view on every instance. Voilà, you get "load balancing"
> and failover. This solution is difficult to implement, though.
>
> Best regards,
> Nils Loeber
>
> "Geoff N. Hiten" <SQLCraftsman@gmail.com> schrieb im Newsbeitrag
> news:OJTQs75ZGHA.504@TK2MSFTNGP03.phx.gbl...
>> There is no native Microsoft SQL load balancing tool for clusters.
>> Microsoft SQL clustering is an availability solution only and has no
>> scale-out benefit.
>>
>> --
>> Geoff N. Hiten
>> Senior Database Administrator
>> Microsoft SQL Server MVP
>>
>>
>>
>>
>> "Leila" <Leilas@hotpop.com> wrote in message
>> news:e14c5u2ZGHA.440@TK2MSFTNGP05.phx.gbl...
>>> Hi,
>>> Are there any solution to implement load balancing on one database
>>> between two nodes of cluster?
>>> Thanks in advance,
>>> Leila
>>>
>>>
>>
>>
>
>