Configuring max degree of parallelism (MAXDOP) in SQL Server

Guidewire recommends setting max degree of parallelism=1 (serial) for regular operations, such as batch processing or online transaction processing (OLTP).

For upgrade and staging table loads, use auto parallelism by setting max degree of parallelism=0. Consider using setting max degree of parallelism=0 when running processes such as database consistency checks, or data distribution reports on a test server.