SQL Server 2019 Express limited to 1 socket/4 cores per instance. Can different instances then use different sockets?
1
vote
1
answer
839
views
We have a SQL Express 2019 server with 3 instances.
The VM has 2 sockets each with 2 cores. The SQL Express licensing specifies that a SQL Express **instance** can use the lessor of 1 socket or 4 cores. So far so good.
Each instance however is picking socket 0 to use, so all 3 instances are sharing 2 cores while the 2 cores on socket 1 are at idle. Is there a way to assign specific instances to specific sockets? The wording of the license seems to indicate that 3 instances on the same machine could use a total of 12 cores, up to 1 socketx4 cores per instance.
Asked by cbedwards
(13 rep)
Jul 5, 2023, 10:09 PM
Last activity: Jul 6, 2023, 12:19 AM
Last activity: Jul 6, 2023, 12:19 AM