Sample Header Ad - 728x90

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