SQL Server 2012 CPU core usage Having some trouble figuring out how to alter the core usage on SQL Server 2012 Enterprise. On a server with 16 cores, is there any way to alter which ones will actively use the SQL database, and not on others?
In SQL Server Management Studio, rt-click on your instance and select Properties. Then select Processors. Uncheck "Automatically set..." and set CPU affinity how you would like.