No parallelism in Express Edition of SQL Server

All we need is an easy explanation of the problem, so here it is.

I have SQL Server 2019 Express Edition (CU8) on Windows Server 2019 (1809 version) and all of my queries go serial with NoParallelPlansInDesktopOrExpressEdition in NoparallelPlanReason property.

Is it that Express Edition never goes parallel? I cannot find anything about this in Microsoft documentation.

No parallelism in Express Edition of SQL Server
No parallelism in Express Edition of SQL Server

How to solve :

I know you bored from this bug, So we are here to help you! Take a deep breath and look at the explanation of your problem. We have many solutions to this problem, But we recommend you to use the first method because it is tested & true method that will 100% work for you.

Method 1

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.

Note: Use and implement method 1 because this method fully tested our system.
Thank you 🙂

All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0

Leave a Reply