Prioritize workloads by login
Have the ability to prioritize workloads based on users.
In both ADW and APS
We have an APS that facilitate user queries and production processes.
In addition to resource groups I would like to have the ability to prioritize a login's workload over other login's.
e.g. Time sensitive Production process over user queries.
The requirement is to be able to differentiate workloads from service accounts and data exploration workloads.
This would prevent lower priority queries from saturating the 32 concurrency slots and give DBAs a mechanism to control this.
If you have a login priority rank of 1 to 5.
1 - higher priority
5 - lower priority
Of the 32 concurrency slots.
Max of 10 concurrency slots for 1 and 2 are prioritized.
Max of 10 concurrency slots for 3 - 4 is prioritized.
The rest is prioritised based on resource class and request submit time.
If there are less than 10 queries for 1-2 or 3-4 then the slots are open to be used by the next priority groups.