Question on number of threads option for Compression
Should cores be considered the same thing as processors, i.e. on a system with a Xeon E5-2680 as described below:
http://ark.intel.com/products/64583/Int ... -Intel-QPI
[*] 2 processors
[*] 8 cores
[*] 16 threads
How many threads should we use?
On a related note my client is seeing his server's cpu usage spike during backups (which are scheduled after hours), cpu usage is peaking > 90% which is causing alerts to go off. Using the configuration above they are using 3 compression setting (out of 4) and have threads set at 6. I recommended turning off compression for a night to see what effect this has on CPU. Any advice would be appreciated, even if it is "It is normal for CPU usage to peak during backups using compression."