Post reply

Clustering 2005.

  • November 4, 2010 at 7:34 am

    #240730

    Hi,

    what is difference between a/a & a/p Clustering ?

    Subha

  • November 4, 2010 at 7:49 am

    #1246541

    Active nodes have at least one sql instance currently running on it.

    Passive nodes do not have any sql instances running on it, but are ready to have another node's instances transferred to it.

    A given sql instance can only be running on one node at a time. So, a/a means that there are at least two sql instances, and then they are currently running on different nodes.

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply