>>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?

Unclear on this end what all is running and even if the robot and the other process both need SQL server. Not enough info to offer more than basic info of what can be done to tweak Windoze machines unless you offer more detail. I interpreted "server" in the headline as the machine, not SQL server process.

If both tasks bottleneck SQL server and thereby drown out one task, you will have to do some semaphoring/priotirizing those calls. Dunno what SQL server offers in that area, maybe Kevin has an idea, but probably he will also first ask for some more info from the logs ;-)

>
>>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.

There are WinAPI calls for that, and AFAIK some processes will read a .cfg file with scheduling entries, but have not verified.