Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question

migrated from Oct 15 '12 at 19:37

This question came from our site for professional and enthusiast programmers.

This is more of a question. – DaveHogan Oct 15 '12 at 18:20
Ahhh okay. Sorry. A little new to posting here. I'l repost it over there. – Adam Hart Oct 15 '12 at 18:24
I think this is a perfectly valid dba question – Pete Carter Oct 15 '12 at 19:40
@PeteCarter - it was originally on stackoverflow. – DaveHogan Oct 15 '12 at 20:55

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.

share|improve this answer
Sorry Eric, your answer had not appeared when I started typing mine!! – Pete Carter Oct 15 '12 at 19:44
+1 back at ya :) – Eric Higgins Oct 15 '12 at 20:37

You can achieve this by using CPU Affinity. This can be controlled by right clicking on the instance, going to properties and then processors.

In this screen, you can set the IO affinity which will control which CPUs/cores that SQL SErver will use.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.