Set SQL Option MAXDOP

  1. On the Data Source tab, expand the tree view to locate the object.
  2. Right-click the source object and select Detailed Properties > Processing Options > Overview.
  3. Click the Add SQL MAXDOP Option button. The SQL Option form is displayed.
  4. Select the Enable Add MAXDOP option.
  5. Specify the number of processors to be used.
    Note:  This should not be more than 8 (based on the generic setting for MAXDOP).
  6. Click OK > OK.
  7. Run the object compilation.