FIX: Allow external resource pool to use more than one processor group in SQL Server 2019 on Windows

Applies to: SQL Server 2019 on Windows

Symptoms


When you try to create or configure external resource pool to use processors from more than one processor group in SQL Server 2019 on Windows, you may encounter the following error:
Msg 10935, Level 16, State 1, Line LineNumber
External resource pool does not allow more than one processor group

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section. 

Resolution


This issue is fixed in the following cumulative update for SQL Server:
About cumulative updates for SQL Server:
Each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included with the previous cumulative update. Check out the latest cumulative updates for SQL Server:

More Information


In Windows Server 2012 and earlier, CPU affinity of only one Processor Group is allowed due to limitation in Windows Job Objects. Hence SQL Server External Resource Governance blocked creation of a Resource Pool with multiple Processor Group affinity. In Windows Server 2016 and later, this Job Object limitation is fixed, and SQL Server can now remove this restriction for the same. After applying this cumulative update you can configure external resource pool to use multiple processor groups.

References


Learn about the terminology that Microsoft uses to describe software updates.