The ALTER SERVER CONFIGURATION with SET SOFTNUMA command does not work correctly in Microsoft SQL Server 2016.
To work around this issue, follow these steps:
- Stop the SQL Server Agent service.
- Run the ALTER SERVER CONFIGURATION with SET SOFTNUMA command.
- Restart Microsoft SQL Server.
Note The new settings will be applied.
- Start SQL Server Agent (optional).
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.