Explain Active/Active and Active/Passive cluster
configurations

Answer Posted / saji joseph

Active/Active

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 ?    22 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the new security features added in sql server 2012? : sql server security

606


How to override dml statements with triggers?

653


How to get a list of columns in a view using the "sp_columns" stored procedure?

703


How can we solve concurrency problems?

674


Does view occupy space?

601






Explain primary key, foreign key and unique key?

654


Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?

664


What are the dis_advantages of stored procedures, triggers, indexes?

1787


What do you mean by stored techniques? How would we use it?

674


How to verify a user name with sqlcmd tool?

692


Give main differences between "Truncate" and "Delete".

671


Explain an automatic checkpoint

647


How to copy data from one table to another table?

648


Name few endpoints exposed by ssrs 2012?

321


How do you use a subquery to find records that exist in one table and do not exist in another?

637