Setting Maximum Degree of Parallelism per query to solve CXPacket waits

• wannabe dba

  SSCommitted

  Points: 1524

  More actions

  November 12, 2008 at 7:33 am

  #196192

  Is there a way to set the MAXDOP to 1 when I run a query and set it back to 0 after the query is done?I see too many CXPacket waits on my database.

  I do not want to use something like

  EXEC sp_configure 'max degree of parallelism',1

  RECONFIGURE WITH OVERRIDE

  which will change setting for all whole server.

• Michael Earl-395764

  SSC Guru

  Points: 53873

  More actions

  November 12, 2008 at 7:51 am

  #897543

  You can use the query hint:

  [font="Courier New"]SELECT

  *

  FROM

  MyTable

  OPTION (MAXDOP 1)[/font]