-
Title
How is degree of parallelism metric being collected? It shows 8 and 16 CPUs for this sometimes. -
Description
Foglight reporting incorrect parallelism. The issues is that the customer has a MAXDOP (Max Degree of Parallelism) of 4 but Foglight is reporting parallelism of 8 and 16. The user wants an explanation. -
Resolution
In reference to Microsoft:
https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-the-max-degree-of-parallelism-server-configuration-option
To enable the server to determine the maximum degree of parallelism, set this option to 0, the default value. Setting maximum degree of parallelism to 0 allows SQL Server to use all the available processors up to 64 processors. To suppress parallel plan generation, set max degree of parallelism to 1. Set the value to a number from 1 to 32,767 to specify the maximum number of processor cores that can be used by a single query execution. If a value greater than the number of available processors is specified, the actual number of available processors is used. If the computer has only one processor, the max degree of parallelism value is ignored.