Combining Stand-alone with a Clustered instance

  • Hello All,

    I have a two node cluster. Let's say N1 is the active node and N2 is the idle one (UP in the cluster manager). I want to install a stand-alone sql server instance on N2 and use it for other purposes. If N1 fails so that the load goes to N2, then N2 will be under a bigger pressure.

    What is your experience/thoughts of this way for extra using the N2 node.

    Igor Micev,My blog: www.igormicev.com

  • Igor Micev (8/19/2016)


    Hello All,

    I have a two node cluster. Let's say N1 is the active node and N2 is the idle one (UP in the cluster manager). I want to install a stand-alone sql server instance on N2 and use it for other purposes.

    Perfectly viable to have clustered and non clustered mixed within a WSFC.

    Igor Micev (8/19/2016)


    If N1 fails so that the load goes to N2, then N2 will be under a bigger pressure.

    What is your experience/thoughts of this way for extra using the N2 node.

    If only N2 has an extra instance, then yes, depending on what said instance is doing, it may put more pressure on the node. You can obviously restrict memory and CPU usage at each instance level

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

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

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