Explain Active/Active and Active/Passive cluster
configurations
- 2 Answers
- 15173 Views
- I also Faced
- E-Mail Answers
Answer Posted / ali
Saji, you answer is ok, but there are some things that need
to be cleared here. Node = Windows Server, Instance = SQL
Server Installation
1.I find that more people use the terms Active/Active and
Active/Passive to detail what the cluster is actually doing
(rather than single instance or multi-instance).
2.An active/passive cluster can have two instances of sql
server running on the active node and the passive node being
idle waiting for a failover to happen.
3.Also, it is not required that in an active/active cluster
one node has default instance and the other node has named
instance, where infact both nodes can have named instances
as part of the virtual server.
ACTIVE/ACTIVE Cluster:
Active/Active clusters is really a mutli-instance (in terms
of SQL Server) cluster with each node owning a running
instance with resources leading to both nodes Actively
running business logic. Both nodes can be possible owners of
each others resources should a failover occur
ACTIVE/PASSIVE Cluster:
Active/Passive clusters is normally single instance of SQL
Server (although I have come across a few cases of
multi-instance) that runs on one node Actively and the other
node does nothing but sit and wait for a failover to occur
(passive node).
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
What is stored in the mssqlsystemresource database? : sql server database administration
What is change data capture (cdc) in sql server 2008?
What is sql server replication? : sql server replication
What do you understand by the data quality services in sql server?
What are the filtered indexes?
Explain what is meant by replication of database?
Tell me what is the order in which the sql query is executed?
Does partitioning improve performance sql server?
What are the differences between sql server and mysql.
Why and when do stored procedure recompile?
In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance
What is a non clustered primary key?
How to get a list of all tables with "sys.tables" view in ms sql server?
What is hot add cpu in sql server 2008?
How can we migrate from SQL server to SQL Azure?
