Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.


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


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


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.


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

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!