Microsoft SQL Affinity Rules
Hello all mighty and knowledgeable ITAM-ers (not sure that's a word...)
I have a question with regards to affinity rules with regards to SQL and would be interested in some thoughts.
We currently have 2 datacenters and we are relocating one of them (let's call it Datacenter B) to a different site. This means that datacenter A will need to take a load from Datacenter B and in order to keep things balanced we'll need to turn off the affinity rules.
My question is, in this scenario, what period of time is acceptable to have these affinity rules down for without breaching compliance? I am aware you get 90 days if a host fails but in this scenario the host hasn't really failed as such. We've been stung by Microsoft over affinity rules in the past so when engineers talk about turning them off, it makes me nervous to say the least. I was wondering if any of you have been through a similar exercise before and can offer any advice.