Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 823
  • Last Modified:

SQL Server CPU settings?

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
Omega002
Asked:
Omega002
  • 2
3 Solutions
 
Kyle AbrahamsSenior .Net DeveloperCommented:
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
 
Omega002Author Commented:
So in your opinion I should keep the settings that have SQL Server using all 8 CPU's?
0
 
anushahannaCommented:
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
 
Kyle AbrahamsSenior .Net DeveloperCommented:
Correct, I would keep it on all 8.  
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now