• The hardware has 8 CPU (Hyper-Threading). CPUs 0 to 5 are Processors Affinity while 6 to 15 are I/O Affinity (because I was seeing entry like this on e in the log "The time stamp counter of CPU on scheduler id 14 is not synchronized with other CPUs")

    Is it OK to have the HT setup for a SQL server? I saw somewhere that it is not recommended, is it right?

    I have set the max memory at 8gb for the SQL and the min to 0 (as mentioned above).