problem in Active / Active clustering

Is active/active clustering is also have load balancing . In Active/ Active
clustering both the node acces the same database or differnt database , In
active/active clustering does the cpu and memory are share by both nodes ?
Please clarify the doubts.
> Is active/active clustering is also have load balancing.
No, it's not for dynamic load balancing, though some may argue that since
you amy be able to distribute your load among the instances in the cluster,
there is some kind of static load balancing. That's really a stretch. SQL
Server clustering is just for high availability.

> In Active/ Active clustering both the node acces the same database
> or differnt database
No two nodes can access the same database at the same time in SQL Server
clustering. This is because Microsoft Cluster Server (on which SQL Server
clustering is built) is designed to allow only one node to have access to a
disk at any given time.

> In active/active clustering does the cpu and memory are share by both
> nodes ?
There is no sharing of cpu or memory. Actually, nothing is shared among the
nodes. You may see terms such as 'shared disk'. That just means that the
disk can be accessed by different nodes (but not at the same time). SQL
Server clustering (or more generally Microsoft Cluster Server) is built on
the shared-nothing model.
SQL Server Books Online has plenty of info on this subject in greater
details. So I'd recommend reading BOL.
Linchi
"sunil" <sunil@.discussions.microsoft.com> wrote in message
news:599435BB-2FE8-4247-BC3A-F92A52FB236F@.microsoft.com...
> Is active/active clustering is also have load balancing . In Active/
> Active
> clustering both the node acces the same database or differnt database ,
> In
> active/active clustering does the cpu and memory are share by both nodes ?
>
> Please clarify the doubts.
>
>
|||Hi Linchi,
Thanks a lot all the doubts have been clarified.Do u have any good white
papaer
Regards
Sunil
"Linchi Shea" wrote:

> No, it's not for dynamic load balancing, though some may argue that since
> you amy be able to distribute your load among the instances in the cluster,
> there is some kind of static load balancing. That's really a stretch. SQL
> Server clustering is just for high availability.
>
> No two nodes can access the same database at the same time in SQL Server
> clustering. This is because Microsoft Cluster Server (on which SQL Server
> clustering is built) is designed to allow only one node to have access to a
> disk at any given time.
>
> There is no sharing of cpu or memory. Actually, nothing is shared among the
> nodes. You may see terms such as 'shared disk'. That just means that the
> disk can be accessed by different nodes (but not at the same time). SQL
> Server clustering (or more generally Microsoft Cluster Server) is built on
> the shared-nothing model.
> SQL Server Books Online has plenty of info on this subject in greater
> details. So I'd recommend reading BOL.
> Linchi
> "sunil" <sunil@.discussions.microsoft.com> wrote in message
> news:599435BB-2FE8-4247-BC3A-F92A52FB236F@.microsoft.com...
>
>
|||This Microsoft whitepaper is worth reading.
http://www.microsoft.com/technet/pro.../failclus.mspx
Linchi
"sunil" <sunil@.discussions.microsoft.com> wrote in message
news:CFB5BA57-42DE-4C27-9CDA-D15CAE961665@.microsoft.com...[vbcol=seagreen]
> Hi Linchi,
> Thanks a lot all the doubts have been clarified.Do u have any good white
> papaer
>
> Regards
> Sunil
> "Linchi Shea" wrote: