>process priority (minimze the one currently downing the others or highten the downed ones)

I still cannot understand why a simple process would basically almost bring down SQL Server. Isn't that database engine suppose to make that transparent?

>processor core affinity (reserve a couple of cores for the downed processes)

What would be the process of assigning a dedicated core to a process? Is it from the Task Manager? If yes, that would mean to execute that manually every time we have a need to.