Atif,
here is the article on how to configure this... this is based on a 3 tier system and a redundant oracle db.
http://www.virtualizationadmin.com/articles-tutorials/vmware-esx-and-vsphere-articles/vmotion-drs-high-availability/configure-vmware-high-availability-vmha.html