Maxdop, does it work against processors or core's?

Question

Maxdop, does it work against processors or core's?

winston Smith

SSCoach

Points: 19500
More actions
October 6, 2010 at 9:21 am

#227593

I have a server with 4, 6 core processors. Does sql server see this as 24 processors?
For testing different values of MAXDOP, what should i be monitoring on a regular basis?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Derrick Smith SSChampion Points: 10833 More actions · Answer 1

It is based on logical cores

This is also why it's typically bad to have hyperthreading enabled..SQL can't tell the difference between an actual core, and the virtual HT core, and sends it data like when it shouldn't.

Jon.Morisi SSChampion Points: 12846 More actions · Answer 2

FYI,

http://support.microsoft.com/kb/970399

Need SP1 CU3 or higher

Derrick Smith SSChampion Points: 10833 More actions · Answer 3

Jon.Morisi (10/6/2010)
FYI,
http://support.microsoft.com/kb/970399
Need SP1 CU3 or higher

Wow...are they serious? The maxdop setting is essentially useless if set to something besides 0 or 1 on all versions of SQL 2008 prior to SP1 CU3?