Solved

SQL Server CPU settings?

Posted on 2011-02-23
4
792 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
  • 2
4 Comments
 
LVL 39

Accepted Solution

by:
Kyle Abrahams earned 334 total points
Comment Utility
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
Comment Utility
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
Comment Utility
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 39

Assisted Solution

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

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.

743 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now