Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to allow SQL Server Express to use multiple cores?

I am currently doing load testing and sqlservr.exe during peak times is using only up to 50% of CPU.

Is there a way to force Sql Server to use more than 50% of CPU?

I am running virtual machine on GoGrid with 2GBs of RAM (2 cores), SQL Server is Express Edition 2008 R2.

Thanks in advance!

like image 865
nikib3ro Avatar asked Dec 28 '22 20:12

nikib3ro


1 Answers

SQL Server Express edition is limited to a single processor.

Edit: MSDN Reference

like image 171
Stu Mackellar Avatar answered Jan 18 '23 20:01

Stu Mackellar