KBA-01831: Cost Threshold for Parallelism and Execution Timeout Expired

Problem:

Users who are attempting the following may occasionally see an Execution Timeout Expired error message:

  • Opening a PO
  • Creating a new project after an update
  • Approving Owner Change Orders
  • Changing the status on a document

Solution:

This particular timeout points to a SQL bottleneck.  There are several possible causes and support will gather logs to help troubleshoot.

One likely case for occasional timeout errors is the default for Cost Threshold for Parallelism setting in SQL is still using the default and should be increased.

See: https://www.brentozar.com/archive/2017/03/why-cost-threshold-for-parallelism-shouldnt-be-set-to-5/


KBA-01831; Last updated: July 20, 2022 at 13:44 pm