UPDATE STATISTICS

• brian118

  Hall of Fame

  Points: 3506

  More actions

  November 23, 2010 at 1:16 am

  #229546

  Hi

  SQL 2008 Enterprise edition 64 bit.

  I have an OLTP db running on an instance which is set to 'max degree of parallelism = 1'. This setting is fine for the application however it will make sense to use more processors to rebuild or update the statistics (FULLSCAN) during a housekeeping exercise. I can specify the MAXDOP option on the ALTER INDEX statement BUT it seems it's not available on the UPDATE STATISTICS statement! Am I missing something, is there a workaround?

  Regards

  Brian

  Regards
  Brian Ellul
  ----------------------------------------------------------------------------------
  Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
  - Albert Einstein -

• Adiga

  One Orange Chip

  Points: 27284

  More actions

  November 23, 2010 at 2:27 am

  #1254247

  Hi Brian,

  UPDATE STATISTICS does not have MAXDOP argument like ALTER INDEX. You need to include the sp_configure script in between. Here is an example.

  sp_configure 'max degree of parallelism', 2

  go

  [UPDATE STATISTIC SCRIPT]

  sp_configure 'max degree of parallelism', 1

  go

  Pradeep Adiga
  Blog: sqldbadiaries.com
  Twitter: @pradeepadiga