Is it better to have parallelism? - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Is it better to have parallelism?

Message

From

13/03/2014 12:16:44

Greg Smith
BMW Group
Easley, South Carolina, United States

To

13/03/2014 10:52:31

Michel Fournier
Level Extreme Inc.
Petit-Rocher, New Brunswick, Canada

General information

Forum:

Microsoft SQL Server

Category:

Other

Title:

Re: Is it better to have parallelism?

Environment versions

SQL Server:

SQL Server 2008

Application:

Web

Miscellaneous

Thread ID:

01596458

Message ID:

01596469

Views:

43

This message has been marked as a message which has helped to the initial question of the thread.

>It is not clear is the usage of a parallelism approach in the execution plan will perform better. It does make the execution more complex but it does not necessarily mean it would be faster. Any feedback on this one?

Check

http://www.brentozar.com/archive/2013/12/q-can-high-maxdop-make-a-query-slower/

Click here to load this message in the networking platform