SQL 2008 CLustering

Question

SQL 2008 CLustering

raheelr 63130

SSC Veteran

Points: 248
More actions
December 16, 2012 at 2:45 pm

#266255

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

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

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

SQLisAwe5oMe SSChampion Points: 14052 More actions · Answer 1

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.

raheelr 63130 SSC Veteran Points: 248 More actions · Answer 2

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

jitendra.padhiyar SSCertifiable Points: 5824 More actions · Answer 3

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.

HowardW One Orange Chip Points: 29109 More actions · Answer 4

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.