November 20, 2020 at 2:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
November 20, 2020 at 2:41 pm
Google Translated, appologies for any miss translations, Googles fault
Personal
I'm with SQL 2019 Enterprise, running on a VM in Sphere 6.5 on a 2-processor server with 24 core, it runs itself on the physical machine. We have a performance problem regarding the processor, we noticed that the offending is SQL, because it does not use all the processing power that Windows has released, being limited to 50%, something is limiting ..... We ran stress software outside of SQL and it scaled the processor to 100% of the Windows processor. Can anyone give a hint?
November 20, 2020 at 2:45 pm
So is that 2 x 24 cores so 48 cores total? Or 2 x 12 core to make 24cores total.
I read it as you have 48 cores as such...
Can you please do an output of "SELECT @@VERSION".
My guess here is you have installed SQL Server Enterprise and not SQL Server Enterprise Core.
SSE only supports the first 20 CPUs
SSEC supports above 20CPUs
Viewing 3 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply