dbTalk Databases Forums  

what's difference between active/active and active/passive

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss what's difference between active/active and active/passive in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Iter
 
Posts: n/a

Default what's difference between active/active and active/passive - 01-22-2008 , 06:23 PM






I have a question regarding configuration of active/active and
active/passive, is there any difference between them when install sql server
software in windows cluster. I look at doc and can not figure out what is
difference between them. Can anybody give me some tips about it? Thanks.


Reply With Quote
  #2  
Old   
Uri Dimant
 
Posts: n/a

Default Re: what's difference between active/active and active/passive - 01-23-2008 , 12:19 AM






Iter
Active/Active.....
As Geoff pointed out in previous post those terminology is for SQL Server
7.0

Shortly

1)Active-Active

You have a cluster configuration with two nodes. On each node you have
intalled SQL Server Instance.
If one node failed over the second one becomes responsible for clinets. It
is important to configure memory properly ( for example if you have 16GB on
two nodes)
assign 5-6GB for each one

2) Active Passive

You have a cluster configuration with two nodes.But at this time you have
intalled SQL Server Instance only on one node (Active)
When it failed over the passive node (computer) becomes an active.


Read these articles

http://searchsqlserver.techtarget.co..._needs_URL.pdf -
---Steps Clustering
http://technet2.microsoft.com/window....mspx?mfr=true
---All about CLustering







"Iter" <Iter (AT) discussions (DOT) microsoft.com> wrote

Quote:
I have a question regarding configuration of active/active and
active/passive, is there any difference between them when install sql
server
software in windows cluster. I look at doc and can not figure out what is
difference between them. Can anybody give me some tips about it? Thanks.




Reply With Quote
  #3  
Old   
Uri Dimant
 
Posts: n/a

Default Re: what's difference between active/active and active/passive - 01-23-2008 , 12:19 AM



Iter
Active/Active.....
As Geoff pointed out in previous post those terminology is for SQL Server
7.0

Shortly

1)Active-Active

You have a cluster configuration with two nodes. On each node you have
intalled SQL Server Instance.
If one node failed over the second one becomes responsible for clinets. It
is important to configure memory properly ( for example if you have 16GB on
two nodes)
assign 5-6GB for each one

2) Active Passive

You have a cluster configuration with two nodes.But at this time you have
intalled SQL Server Instance only on one node (Active)
When it failed over the passive node (computer) becomes an active.


Read these articles

http://searchsqlserver.techtarget.co..._needs_URL.pdf -
---Steps Clustering
http://technet2.microsoft.com/window....mspx?mfr=true
---All about CLustering







"Iter" <Iter (AT) discussions (DOT) microsoft.com> wrote

Quote:
I have a question regarding configuration of active/active and
active/passive, is there any difference between them when install sql
server
software in windows cluster. I look at doc and can not figure out what is
difference between them. Can anybody give me some tips about it? Thanks.




Reply With Quote
  #4  
Old   
Uri Dimant
 
Posts: n/a

Default Re: what's difference between active/active and active/passive - 01-23-2008 , 12:19 AM



Iter
Active/Active.....
As Geoff pointed out in previous post those terminology is for SQL Server
7.0

Shortly

1)Active-Active

You have a cluster configuration with two nodes. On each node you have
intalled SQL Server Instance.
If one node failed over the second one becomes responsible for clinets. It
is important to configure memory properly ( for example if you have 16GB on
two nodes)
assign 5-6GB for each one

2) Active Passive

You have a cluster configuration with two nodes.But at this time you have
intalled SQL Server Instance only on one node (Active)
When it failed over the passive node (computer) becomes an active.


Read these articles

http://searchsqlserver.techtarget.co..._needs_URL.pdf -
---Steps Clustering
http://technet2.microsoft.com/window....mspx?mfr=true
---All about CLustering







"Iter" <Iter (AT) discussions (DOT) microsoft.com> wrote

Quote:
I have a question regarding configuration of active/active and
active/passive, is there any difference between them when install sql
server
software in windows cluster. I look at doc and can not figure out what is
difference between them. Can anybody give me some tips about it? Thanks.




Reply With Quote
  #5  
Old   
Uri Dimant
 
Posts: n/a

Default Re: what's difference between active/active and active/passive - 01-23-2008 , 12:19 AM



Iter
Active/Active.....
As Geoff pointed out in previous post those terminology is for SQL Server
7.0

Shortly

1)Active-Active

You have a cluster configuration with two nodes. On each node you have
intalled SQL Server Instance.
If one node failed over the second one becomes responsible for clinets. It
is important to configure memory properly ( for example if you have 16GB on
two nodes)
assign 5-6GB for each one

2) Active Passive

You have a cluster configuration with two nodes.But at this time you have
intalled SQL Server Instance only on one node (Active)
When it failed over the passive node (computer) becomes an active.


Read these articles

http://searchsqlserver.techtarget.co..._needs_URL.pdf -
---Steps Clustering
http://technet2.microsoft.com/window....mspx?mfr=true
---All about CLustering







"Iter" <Iter (AT) discussions (DOT) microsoft.com> wrote

Quote:
I have a question regarding configuration of active/active and
active/passive, is there any difference between them when install sql
server
software in windows cluster. I look at doc and can not figure out what is
difference between them. Can anybody give me some tips about it? Thanks.




Reply With Quote
  #6  
Old   
Uri Dimant
 
Posts: n/a

Default Re: what's difference between active/active and active/passive - 01-23-2008 , 12:19 AM



Iter
Active/Active.....
As Geoff pointed out in previous post those terminology is for SQL Server
7.0

Shortly

1)Active-Active

You have a cluster configuration with two nodes. On each node you have
intalled SQL Server Instance.
If one node failed over the second one becomes responsible for clinets. It
is important to configure memory properly ( for example if you have 16GB on
two nodes)
assign 5-6GB for each one

2) Active Passive

You have a cluster configuration with two nodes.But at this time you have
intalled SQL Server Instance only on one node (Active)
When it failed over the passive node (computer) becomes an active.


Read these articles

http://searchsqlserver.techtarget.co..._needs_URL.pdf -
---Steps Clustering
http://technet2.microsoft.com/window....mspx?mfr=true
---All about CLustering







"Iter" <Iter (AT) discussions (DOT) microsoft.com> wrote

Quote:
I have a question regarding configuration of active/active and
active/passive, is there any difference between them when install sql
server
software in windows cluster. I look at doc and can not figure out what is
difference between them. Can anybody give me some tips about it? Thanks.




Reply With Quote
  #7  
Old   
Uri Dimant
 
Posts: n/a

Default Re: what's difference between active/active and active/passive - 01-23-2008 , 12:19 AM



Iter
Active/Active.....
As Geoff pointed out in previous post those terminology is for SQL Server
7.0

Shortly

1)Active-Active

You have a cluster configuration with two nodes. On each node you have
intalled SQL Server Instance.
If one node failed over the second one becomes responsible for clinets. It
is important to configure memory properly ( for example if you have 16GB on
two nodes)
assign 5-6GB for each one

2) Active Passive

You have a cluster configuration with two nodes.But at this time you have
intalled SQL Server Instance only on one node (Active)
When it failed over the passive node (computer) becomes an active.


Read these articles

http://searchsqlserver.techtarget.co..._needs_URL.pdf -
---Steps Clustering
http://technet2.microsoft.com/window....mspx?mfr=true
---All about CLustering







"Iter" <Iter (AT) discussions (DOT) microsoft.com> wrote

Quote:
I have a question regarding configuration of active/active and
active/passive, is there any difference between them when install sql
server
software in windows cluster. I look at doc and can not figure out what is
difference between them. Can anybody give me some tips about it? Thanks.




Reply With Quote
  #8  
Old   
Uri Dimant
 
Posts: n/a

Default Re: what's difference between active/active and active/passive - 01-23-2008 , 12:19 AM



Iter
Active/Active.....
As Geoff pointed out in previous post those terminology is for SQL Server
7.0

Shortly

1)Active-Active

You have a cluster configuration with two nodes. On each node you have
intalled SQL Server Instance.
If one node failed over the second one becomes responsible for clinets. It
is important to configure memory properly ( for example if you have 16GB on
two nodes)
assign 5-6GB for each one

2) Active Passive

You have a cluster configuration with two nodes.But at this time you have
intalled SQL Server Instance only on one node (Active)
When it failed over the passive node (computer) becomes an active.


Read these articles

http://searchsqlserver.techtarget.co..._needs_URL.pdf -
---Steps Clustering
http://technet2.microsoft.com/window....mspx?mfr=true
---All about CLustering







"Iter" <Iter (AT) discussions (DOT) microsoft.com> wrote

Quote:
I have a question regarding configuration of active/active and
active/passive, is there any difference between them when install sql
server
software in windows cluster. I look at doc and can not figure out what is
difference between them. Can anybody give me some tips about it? Thanks.




Reply With Quote
  #9  
Old   
Uri Dimant
 
Posts: n/a

Default Re: what's difference between active/active and active/passive - 01-23-2008 , 12:19 AM



Iter
Active/Active.....
As Geoff pointed out in previous post those terminology is for SQL Server
7.0

Shortly

1)Active-Active

You have a cluster configuration with two nodes. On each node you have
intalled SQL Server Instance.
If one node failed over the second one becomes responsible for clinets. It
is important to configure memory properly ( for example if you have 16GB on
two nodes)
assign 5-6GB for each one

2) Active Passive

You have a cluster configuration with two nodes.But at this time you have
intalled SQL Server Instance only on one node (Active)
When it failed over the passive node (computer) becomes an active.


Read these articles

http://searchsqlserver.techtarget.co..._needs_URL.pdf -
---Steps Clustering
http://technet2.microsoft.com/window....mspx?mfr=true
---All about CLustering







"Iter" <Iter (AT) discussions (DOT) microsoft.com> wrote

Quote:
I have a question regarding configuration of active/active and
active/passive, is there any difference between them when install sql
server
software in windows cluster. I look at doc and can not figure out what is
difference between them. Can anybody give me some tips about it? Thanks.




Reply With Quote
  #10  
Old   
Uri Dimant
 
Posts: n/a

Default Re: what's difference between active/active and active/passive - 01-23-2008 , 12:19 AM



Iter
Active/Active.....
As Geoff pointed out in previous post those terminology is for SQL Server
7.0

Shortly

1)Active-Active

You have a cluster configuration with two nodes. On each node you have
intalled SQL Server Instance.
If one node failed over the second one becomes responsible for clinets. It
is important to configure memory properly ( for example if you have 16GB on
two nodes)
assign 5-6GB for each one

2) Active Passive

You have a cluster configuration with two nodes.But at this time you have
intalled SQL Server Instance only on one node (Active)
When it failed over the passive node (computer) becomes an active.


Read these articles

http://searchsqlserver.techtarget.co..._needs_URL.pdf -
---Steps Clustering
http://technet2.microsoft.com/window....mspx?mfr=true
---All about CLustering







"Iter" <Iter (AT) discussions (DOT) microsoft.com> wrote

Quote:
I have a question regarding configuration of active/active and
active/passive, is there any difference between them when install sql
server
software in windows cluster. I look at doc and can not figure out what is
difference between them. Can anybody give me some tips about it? Thanks.




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.