16,755 pts.
 How many processors can SQL Server 2008 R2 support?
How many processors can SQL Server 2008 R2 support?

Software/Hardware used:
ASKED: May 5, 2010  8:18 PM
UPDATED: September 9, 2010  6:49 AM

Answer Wiki:
SQL Server Datacenter Edition can support up to 256 logical processors when deployed on Windows Server 2008 R2. Standard Edition can support 4 physical CPUs, and Enterprise can support 8 Physical processors. Workgroup Edition can support 2 physical CPUs, and SQL Express can support 1 physical CPUs.
Last Wiki Answer Submitted:  May 6, 2010  1:14 am  by  MicrosoftExpert   975 pts.
All Answer Wiki Contributors:  MicrosoftExpert   975 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _


 

hi,

I have sql server Stander 2008 R2,on web server,my most of client faced the issue with slow speed,some time time out,,if i goes to check the processor graph,it hits maximum 11 GB ram,and processor gets 90%,can some one suggest what i have to do fro the same.

Thanks

 10 pts.