BorderLayoutBoxedLayoutOpenLayoutMaximum textMedium textSmall text


Register
Tuesday, March 09, 2010
MyStreamMinimize
Print  

Entries for the 'SQLOS' Category

NUMA and MAXDOP

Posted by Jason Massie Click to IM Jason Massie on Monday, March 17, 2008 at 1:00 PM to SQL Server 2008, SQL Server 2005, SQLOS
1491 Views | 0 Comments | Article Rating

On the SWYNK mailing list, Linchi and Cindy were taking about MAXDOP when Cindy mentioned the NUMA best practice. I did a quick google hoping it was documented to make it easier to persuade customers and badda bing... 

Use the following guidelines when you configure the MAXDOP value:

• For servers that use more than eight processors, use the following configuration: MAXDOP=8.

• For servers that have eight or less processors, use the following configuration where N equals the number of processors: MAXDOP=0 toN.

• For servers that have NUMA configured, MAXDOP should not exceed the number of CPUs that are assigned to each NUMA node.

• For servers that have hyper-threading enabled, the MAXDOP value should not exceed the number of physical processors.

Technorati Tags: ,,,

email it! |   |   | 

SQL Shorts

Posted by Jason Massie Click to IM Jason Massie on Sunday, February 10, 2008 at 9:47 PM to SQL Server 2008, SQL Server 2005, Heroes Happen Here, SQL performance tuning, SQLOS, internals, scheduler
1658 Views | 0 Comments | Article Rating

Kalen Delaney's first DVD on SQL Server internals is available for viewing online. More details here.

Connor Cunningham, formerly on the SQL query optimizer team, is now blogging at SQL Skills and is whipping out posts on optimizer related topics at a frantic pace. Check out the latest here or all of them here.

Dan Jones rebuffs the idea that SQL Server 2008 is a "dot release".

CTP6 may or may not be coming soon. Chris says that CTP5 will be given away at the HHH launch. This is in contrast to the "feature complete" CTP that was mentioned in the roadmap but who know...

Mario B has raised some eyebrows with his post on scheduler troubleshooting and SOS_SCHEDULER_YIELD waits and the possibility that is is not CPU pressure always. Linchi posted about it here and then SQLServerPedia posts shortly afterwards. Anyway, check out Mario's tools.

email it! |   |   | 

Page 1 of 1First   Previous   Next   Last   


Copyright 2006 by Statistics IO, My SQL Server Blog