The max degree of parallelism option determines the maximum number of processors to use in parallel plan execution. If the SQL Server Database Engine detects that the system is busy, the degree of parallelism of the index operation is automatically reduced before statement execution starts. GeoPITS brings you the comprehensive details of Parallel indexed operations's support in different versions & editions of SQL Server.
| Version | Enterprise | Standard | Web | Express (Adv.) | Express |
|---|---|---|---|---|---|
| Version v2019 | Yes | ||||
| Version v2017 | Yes | ||||
| Version v2016 | Yes | ||||
| Version v2014 | |||||
| Version v2012 |
The max degree of parallelism option determines the maximum number of processors to use in parallel plan execution. If the SQL Server Database Engine detects that the system is busy, the degree of parallelism of the index operation is automatically reduced before statement execution starts
You can find more details about this version here
Back to all features