开发者

How to allow SQL Server Express to use multiple cores?

开发者 https://www.devze.com 2023-03-04 13:47 出处:网络
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 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 r开发者_高级运维unning virtual machine on GoGrid with 2GBs of RAM (2 cores), SQL Server is Express Edition 2008 R2.

Thanks in advance!


SQL Server Express edition is limited to a single processor.

Edit: MSDN Reference


Please make sure that the virtual machine is set to use all available cpu cores.

0

精彩评论

暂无评论...
验证码 换一张
取 消