Morning All,
Has anyone put any logic into their classifier function that checks to see if named availability groups are active on the same server.
What I am investigating is the following scenario.
Consider I have 3 Replicas and 3 Availability groups. They all tend to reside on different replicas.
When a group moves to another replica so that there are now 2 (and possibly 3) groups to one server I want the resource governor to throttle the resources for a given login that relates to that availability group (each group has a separate login anyway).
I'll let the business dictate what kind of priority they want to give each availability group but for initial testing I was thinking of just counting the number of active availability groups and using that number as the divisor for resources...
Has anyone done this before? With success? Without success?
Is it a bad idea?
Cheers all for your help
Alex