Explain Active/Active and Active/Passive cluster
configurations?

Answer Posted / suman j

Here first node will be default and second node will be
named instance. Both node will be active.

Move group from cluster administration is possible for both
side.

System performance will go down, if both resources are in
one node.

Active/Passive

Only one Active node with default instance.
No system performance degradation will be there for this
case even if we switchover to the other node. Both have
same configuration.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to turn on the mssql api module in php?

759


How to get the definition of a user defined function back?

805


Difference between aggregate functions of sql?

835


Define Wed Edition in SQL Azure?

92


What is a trigger what are the advantages of trigger?

694






What is a filestream?

735


what types of replication are supported in sql server? : Sql server database administration

657


what is a self join? : Sql server database administration

694


Can we create clustered index on composite key?

686


What is the difference between a view and a stored procedure?

759


How many levels of sp nesting are possible?

756


What is the difference between ddl,dml and dcl commands?

810


Is there any difference between primary key and unique with the not null condition?

702


What are the different types of cursor?

814


What is merge?

742