Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
yelouati
Starting Member
10 Posts |
 Posted - 2013-08-23 : 20:26:53
|
| Hi All,I am in a bit of a pickles. During a load test I discovered that SQL was using 8 CPUs (100%) while not using the other 24.The 8 CPUs belong to the same NUMA node.This is SQL 2012 SP1 (3000).Interestingly, if within Windows (NOT PROCESSOR AFFINITY MASK in SQL) I set the affinity to more CPUs, it takes them and the transaction times drop significantly.Since the concurrent running code is the same SP, I am guessing SQL is using processors closer to the memory map. But how clumsy.Anyone has any ideas how I can make use of all CPUs?Thanks |
|
|
yelouati
Starting Member
10 Posts |
|
|
|
|
|
SQL using 8 CPUs out of 32