Is it better to have parallelism? - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Is it better to have parallelism?

Message

De

13/03/2014 12:16:44

Greg Smith
BMW Group
Easley, Caroline du Sud, États-Unis

À

13/03/2014 10:52:31

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

Information générale

Forum:

Microsoft SQL Server

Catégorie:

Autre

Titre:

Re: Is it better to have parallelism?

Versions des environnements

SQL Server:

SQL Server 2008

Application:

Web

Divers

Thread ID:

01596458

Message ID:

01596469

Vues:

44

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