maxdop Image

maxdop

question
philmac750 avatar image
philmac750 answered Default

MaxDOP and CostThresholdForParallelism

performance parallelism maxdop

0 Likes

1Answer

0 Comments

question
ahaware avatar image
ahaware commented Default

Same Query, Different Servers, Different Performance. Now What?

performance maxdop

0 Likes

2Answers

1 Comment

question
GPO avatar image
GPO edited Default

Changing maximum degrees of parallelism

parallelism maxdop query hints single-thread

This question has an accepted answer. Accepted

2 Likes

1Answer

0 Comments

question
Grant Fritchey avatar image
Grant Fritchey commented Default

why does maxdop = 0 cause query to fail app?

maxdop

2 Likes

2Answers

7 Comments

question
GPO avatar image
GPO edited Default

VM ESX hosts have hyperthreaded cores enabled on database server.

server maxdop vm hyperthreading

This question has an accepted answer. Accepted

1 Like

1Answer

0 Comments

question
letter1 avatar image
letter1 Suspended answered Default

maxdop, hyperthreading, and Sandy Bridge

maxdop

3 Likes

3Answers

2 Comments

question
ThomasRushton avatar image
ThomasRushton converted answer to comment Default

CXPACKET with High Waittime

maxdop

This question has an accepted answer. Accepted

2 Likes

1Answer

1 Comment

question
Pavel Pawlowski avatar image
Pavel Pawlowski edited Default

MAXDOP for SSIS

ssis sql-server-2008-r2 maxdop

1 Like

3Answers

0 Comments

question
Raj More avatar image
Raj More edited Default

Change MaxDop of a running query

sql-server-2008-r2 maxdop

0 Likes

2Answers

2 Comments

9 Posts
8 Users
0 Followers

Topic Experts

There are currently no experts identified for this topic. Can you answer questions in this topic area? Community members who provide answers that are marked as correct earn reputation and may become recognized as topic experts.