patternsqlMinor
No parallelism in Express Edition of SQL Server
Viewed 0 times
expresseditionsqlserverparallelism
Problem
I have SQL Server 2019 Express Edition (CU8) on Windows Server 2019 (1809 version) and all of my queries go serial with
Is it that Express Edition never goes parallel? I cannot find anything about this in Microsoft documentation.
NoParallelPlansInDesktopOrExpressEdition in NoparallelPlanReason property.Is it that Express Edition never goes parallel? I cannot find anything about this in Microsoft documentation.
Solution
The limitation is mentioned in the Query Processing Architecture Guide under the "Parallel Query Processing" section:
Parallel plans not supported for Desktop and Express edition.
The Editions and supported features of SQL Server 2019 (15.x) documentation says (under "Scale Limits") that Express is:
Limited to lesser of 1 socket or 4 cores
But that is just related to how many cores you can make available to the database engine.
It doesn't say anything about parallel plans (other than a limitation related to batch mode operations being limited to 1 core on Express Edition).
All that to say that it looks like Express really doesn't allow parallel plans at all. I tried running queries on SQL Server 2019 and 2014 with the same NonParallelPlanReason given, so it doesn't appear to be a new limitation either.
Parallel plans not supported for Desktop and Express edition.
The Editions and supported features of SQL Server 2019 (15.x) documentation says (under "Scale Limits") that Express is:
Limited to lesser of 1 socket or 4 cores
But that is just related to how many cores you can make available to the database engine.
It doesn't say anything about parallel plans (other than a limitation related to batch mode operations being limited to 1 core on Express Edition).
All that to say that it looks like Express really doesn't allow parallel plans at all. I tried running queries on SQL Server 2019 and 2014 with the same NonParallelPlanReason given, so it doesn't appear to be a new limitation either.
Context
StackExchange Database Administrators Q#289916, answer score: 8
Revisions (0)
No revisions yet.