June 5, 2017 at 1:21 am
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
October 16, 2017 at 2:21 pm
alex.sqldba - Monday, June 5, 2017 1:21 AMMorning 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
Hi Alex,
We are on the same page, I am also looking for that solution, I tried implementing using listener IP's but no luck.. 🙁
Let me know if you find any solution....
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply