ACTIVE/ACTIVE SQL Server Cluster Model
Windows Server Forum Index Windows Server
Server discussion on Windows platform.
 
 FAQFAQ   MemberlistMemberlist     RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
 
Google
 
Web winserverhelp.com
ACTIVE/ACTIVE SQL Server Cluster Model

 
Post new topic   Reply to topic    Windows Server Forum Index -> Clustering
Author Message
christian da ruos
Guest
Posted: Mon Jan 31, 2005 6:46 am    Post subject: ACTIVE/ACTIVE SQL Server Cluster Model Reply with quote
Does anyone have already implemented an active/active (multiple instance)
Sql Server Cluster ? What are the benefits/disvantages over an
active/passive mode ?

Thanks for your answers !

Chris
Back to top
Russ Kaufmann
Guest
Posted: Mon Jan 31, 2005 6:46 am    Post subject: Re: ACTIVE/ACTIVE SQL Server Cluster Model Reply with quote
"christian da ruos" <chris.daruos@sellys.com> wrote in message
news:%23bdEuu5BFHA.2076@TK2MSFTNGP15.phx.gbl...
Quote:
Does anyone have already implemented an active/active (multiple instance)
Sql Server Cluster ? What are the benefits/disvantages over an
active/passive mode ?

I support two different sets of SQL clusters in an active-active
configuration.

Benefits - while in active-active, the performance is better with the
different SQL instances on different virtual servers on different nodes.

Disadvantage - performance take a major hit during a failure.
Back to top
christian da ruos
Guest
Posted: Wed Feb 02, 2005 6:08 pm    Post subject: Re: ACTIVE/ACTIVE SQL Server Cluster Model Reply with quote
Hi Russ,

Thanks for your answer.

I will be in charge of implement a cluster of 2 Sql Server 2000 but I am not
yet sure about
the choice I will do between active/active and active/passive mode.

Would it be possible for you to send me your configuration settings
(architecture) you are
running on your cluster ? Does your actual configuration give you full
satisfaction ? Is it
possible to use the cluster as a state server for asp.net applications ?

Best regards !

Chris

"Russ Kaufmann" <russ@exchangemct.com> wrote in message
news:u4n1jX7BFHA.824@TK2MSFTNGP11.phx.gbl...
Quote:
"christian da ruos" <chris.daruos@sellys.com> wrote in message
news:%23bdEuu5BFHA.2076@TK2MSFTNGP15.phx.gbl...
Does anyone have already implemented an active/active (multiple instance)
Sql Server Cluster ? What are the benefits/disvantages over an
active/passive mode ?

I support two different sets of SQL clusters in an active-active
configuration.

Benefits - while in active-active, the performance is better with the
different SQL instances on different virtual servers on different nodes.

Disadvantage - performance take a major hit during a failure.
Back to top
Russ Kaufmann
Guest
Posted: Thu Feb 03, 2005 12:19 am    Post subject: Re: ACTIVE/ACTIVE SQL Server Cluster Model Reply with quote
"christian da ruos" <chris.daruos@sellys.com> wrote in message
news:O8taRASCFHA.1924@TK2MSFTNGP14.phx.gbl...

Quote:
Would it be possible for you to send me your configuration settings
(architecture) you are
running on your cluster ?

Sorry, I can't. However, it really doesn't make a difference as each one is
pretty much the default setting. I don't think there are any changes from
default configurations.

Quote:
Does your actual configuration give you full
satisfaction ?

No, I am still hungry. <G> Does it work? Absolutely. It runs very well.

Quote:
Is it
possible to use the cluster as a state server for asp.net applications ?

You can use it for any purpose where you would normally use SQL.
Back to top
 
Post new topic   Reply to topic    Windows Server Forum Index -> Clustering All times are GMT
Page 1 of 1

 
 You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum




New Topics Powered by phpBB