Question

You manage a SQL Server 2022 instance on an Azure VM that hosts both an interactive point-of-sale application and a nightly bulk-import service account. Users complain that during imports, POS response times degrade badly. You want to guarantee the POS workload gets a larger share of CPU while capping the import workload, and requests must be assigned to the correct resource pool based on the connecting login. After creating two resource pools and two workload groups, what must you also do to route sessions to the appropriate group?

Accepted Answer

Create and register a classifier user-defined function that returns the workload group name, then reconfigure Resource Governor

Answer

Assign each login a MAX_CPU_PERCENT value directly in the login properties

Answer

Create an Extended Events session that redirects sessions to the correct workload group at connection time

Answer

Add the logins to the resource pool definition using ALTER RESOURCE POOL