September 12, 2019 at 1:57 pm
Is hyperthreading enabled? The product has been shown to work with hundreds of cores. I think you're missing something in your view.
September 12, 2019 at 3:08 pm
I was thinking maybe you are missing a patch for either Windows (more likely) or SQL Server, what comes first to my mind is: Is it a newer AMD Epyc / Xenon Scalable Server?
If so for these MCM Designs at least for better scheduling a patch was released a while ago, maybe it has something to do with that? At least the CPU core count (wether the actual or what SQL Server might be thinking) is nothing to worry about really, I've seen 64 Core Systems (128 Threads) work without any issue with MSSQL Server at least.
September 16, 2019 at 3:14 am
It is enabled...
C:\Windows\system32>wmic
wmic:root\cli>CPU Get NumberOfCores,NumberOfLogicalProcessors /Format:List
NumberOfCores=18
NumberOfLogicalProcessors=36
NumberOfCores=18
NumberOfLogicalProcessors=36
wmic:root\cli>
September 16, 2019 at 3:15 am
we have multiple instances installed on that those servers, I can assign cpu affinity to logical cores not exists, it is working, but I just don't know how it works...
September 16, 2019 at 3:27 am
It is Intel(R) Xeon(R) Gold 6254 CPU @ 3.10GHz.
I have not found anyone else reported the same issue I have.
Viewing 5 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply