run_value and config_value are different for max degree of parallelism

• SQL_Hunt

  SSC-Dedicated

  Points: 33518

  More actions

  April 13, 2016 at 10:40 am

  #306368

  Hi,

  Question 1:

  If we see config_value and run_value are different for 'max degree of parallelism', then the question is, whether SQL Server will use the value of

  'config_value' or 'run_value' while running the queries?

  Per the MSDN link, https://technet.microsoft.com/en-us/library/ms188787(v=sql.105).aspx

  it looks like the it should be "run_value" which is being used to run the queries.

  And the reason why the values (config vs run) are different, because the DBA missed to run : RECONFIGURE WITH OVERRIDE;

  Question 2:

  Is there any trouble, having two different values?

  Thanks.

• BLOB EATER

  SSChampion

  Points: 14609

  More actions

  April 14, 2016 at 1:04 am

  #1871906

  well I believe they are going to be different until you run reconfigure command... (as you rightly mentioned)

  Just be careful with RECONFIGURE WITH OVERRIDE I have seen some weird settings due to how it works.