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
What are the new security features added in sql server 2012? : sql server security
How to override dml statements with triggers?
How to get a list of columns in a view using the "sp_columns" stored procedure?
How can we solve concurrency problems?
Does view occupy space?
Explain primary key, foreign key and unique key?
Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?
What are the dis_advantages of stored procedures, triggers, indexes?
What do you mean by stored techniques? How would we use it?
How to verify a user name with sqlcmd tool?
Give main differences between "Truncate" and "Delete".
Explain an automatic checkpoint
How to copy data from one table to another table?
Name few endpoints exposed by ssrs 2012?
How do you use a subquery to find records that exist in one table and do not exist in another?