Is it possible to configure SQL Server in such a way that it only uses one of the 2 CPU's in a server? At present, the server contains 2 x 12 core CPUs, but we want to prevent SQL using the second processor completely.
I was looking around in the Processors property, and noticed that, at present, under "Enable Processors" both the Automatic set processor affinity mask for all processors, and the Automatically set IO affinity mask for all processors options were both checked.
What changes can I make to make only 1 CPU active without actually removing the CPU physically?
I was looking at assigning 6 cores to IO and 6 cores to Processor, and not including ANY CPU's from the second processor?
We are running SQL 2008 R2 Standard x64 on Windows 2008 R2 Standard x64.
Microsoft führt eine Onlineumfrage durch, um Ihre Meinung zur Msdn Website zu erfahren. Wenn Sie sich zur Teilnahme entscheiden, wird Ihnen die Onlineumfrage angezeigt, sobald Sie die Msdn Website verlassen.