Recently I reviewed some public posts on Desire2Learn SQL Server Performance and extracted some recommendations of common issues:
Often, I have seen an increase of CPUs without increasing RAM or the number of TempDB files. Each CPU (or core on a CPU) creates a "mini-PC". A configuration with 4 GB RAM and 1 CPU may perform worst with a six-core CPU and 4 GB of RAM in some situations. A few simple rule of thumb may help you here:
For those that are interest in reading experiences more, here are a few of the items that I reviewed:
There are many ways to determine this. One simple way is to:
Technical details: Intel hyperthreads will appear as CPUs but should not be count as CPUs. A common SQL Server practice is to disable the hyperthreading on Intel Chips (for more information).
To determine this: