Solved

SQL Server CPU settings?

Posted on 2011-02-23
4
803 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 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
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 utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how the fundamental information of how to create a table.

809 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