Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 High Availability (2005)
 Active to Active

Author  Topic 

ksr39
Posting Yak Master

193 Posts

Posted - 2011-08-23 : 10:05:41
Hi All,

Im new to Cluster...
Please suggest me as we have a two node cluster (Active-Passive) in our environment and due to some performance issues we want to change that environment to Active-Active. and please let me know how to change a Active-Passive nodes to Active-Active nodes. Please suggest me if we do it like this from active-passive to Active-Active Nodes, Will there be any issues.


Thanks In Advance.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-08-23 : 13:39:34
All you have to do is install a new instance and have it run on the other node. Please note that Windows clustering does not give you load balancing.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

ksr39
Posting Yak Master

193 Posts

Posted - 2011-08-23 : 13:46:48
Thank You Kizer.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-08-23 : 14:36:31
You're welcome, glad to help.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2011-08-23 : 14:53:05
quote:
Originally posted by ksr39

Hi All,

Im new to Cluster...
Please suggest me as we have a two node cluster (Active-Passive) in our environment and due to some performance issues we want to change that environment to Active-Active. and please let me know how to change a Active-Passive nodes to Active-Active nodes. Please suggest me if we do it like this from active-passive to Active-Active Nodes, Will there be any issues.


Thanks In Advance.



How do you expect that this will solve performance issues?

Are you under the impression that you can have a SQL Server instance active on more than one node?



CODO ERGO SUM
Go to Top of Page
   

- Advertisement -