SQL 2008 CLustering

  • Team, I need to set-up clustering and need your thoughts and ideas whether i should have my primay server on physical and secondary on virtual or both virtual or both pyshical. This is for my production environment.

    Regards

    Raheel

  • raheelr 63130 (12/16/2012)


    Team, I need to set-up clustering and need your thoughts and ideas whether i should have my primay server on physical and secondary on virtual or both virtual or both pyshical. This is for my production environment.

    Regards

    Raheel

    Not sure if I understand your requirement, please clarify.

    SueTons.

    Regards,
    SQLisAwe5oMe.

  • Hi, I am planning to set-up my production ennvironment. I am wanting to know if its best to have the primary node as a physical server and the secondary node as virtual server? or both the nodes should be on physical.

    I am using windows 2008 clustering and sql 2008.

    Regards

    Raheel

  • Hi Raheel,

    You can use both the node either physical or both of them virtual, its upon you. But to save hardware cost you can go with Virtulisation.

  • Whilst it's not an absolute requirement to have matching hardware for servers in the cluster, it is recommended and makes configuration easier in general. I've never heard of people using a physical/virtual hybrid cluster, but I can't think of an absolute reason why it isn't possible. You're more likely to run into issues with unusual configurations though.

    Whether they're both physical or both virtual is your call, both can work well assuming your server team sets them up competently. Obviously in a virtual environment, make sure that the VMs are running on physically separate hardware or you're defeating the object of a cluster.

Viewing 5 posts - 1 through 4 (of 4 total)

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