On our SQL Server hardware, we have two quad core CPUs (8 CPUs from SQL server perspective)
I understand that I can limit SQL Server to take only 1 core (4 CPUs) out of 8 CPUS, but my understanding is it might be shared with OS depends of the load of other
applications running on the server.
Is there any way to configure the server (OS+SQL Server) that dedicate 1 core (4 CPUs) to SQL server and allocate the rest of CPUs for OS and the rest of running
applications including Integration Services?
My understanding is dedicated CPUs to SQL Server doesn’t include SSIS. Is that right?
View Complete Post