I have a 4 host cluster in our VMware environment. 3 of the 4 hosts are identical boxes, and one is newer. When I do a migration with one of our virtual machines between one of the older hosts and the new host, or vice-versa, it breaks our licensing for Pervasive SQL software. I called support and Pervasive says this is expected, and if we want to have this in a virtual environment, then we need to setup CPU affinity for the VM hosting the Pervasive SQL server. We have DRS enabled. Am I still able to set CPU affinity for this VM? Would I be better off assigning the VM itself to a physical host? Or does DRS prevent that too?
Any ideas I'm not thinking of to address this issue?