Solved

SQL Server CPU settings?

Posted on 2011-02-23
4
810 Views
Last Modified: 2012-08-14
We have a production server that has 16gb and 8 CPU's. SQL Server 2008 is currently using all 8 CPU's. I thought you should not use the first CPU when configuring SQL Server so you should not use CPU1 but you can configure CPU2-CPU8 for optimal performance so the OS will have dedicated CPU that is does not share with SQL Server. What are you thoughts on this?
0
Comment
Question by:Omega002
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 40

Accepted Solution

by:
Kyle Abrahams earned 334 total points
ID: 34963444
It makes some sense, but at the same time if all you're running is SQL after the OS is loaded there's not too much for the OS to do and you have that whole idle CPU there just begging to be used.  If you could configure Priority by CPU then you could set CPU 1 SQL to low but I don't think windows is there yet.

Other comments:
http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server-programming/52696/Reserve-One-CPU-for-OS

http://www.sqlnewsgroups.net/group/microsoft.public.sqlserver.server/topic24578.aspx
0
 

Author Comment

by:Omega002
ID: 34964308
So in your opinion I should keep the settings that have SQL Server using all 8 CPU's?
0
 
LVL 6

Assisted Solution

by:anushahanna
anushahanna earned 166 total points
ID: 34964412
the main best practice regarding CPU is

configuration of TEMPDB database (Lining up the number of data files with CPU’s has scalability advantages for allocation intensive workloads.)
http://technet.microsoft.com/en-us/library/cc966534.aspx
0
 
LVL 40

Assisted Solution

by:Kyle Abrahams
Kyle Abrahams earned 334 total points
ID: 34971012
Correct, I would keep it on all 8.  
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question