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
Is it that Express Edition never goes parallel? I cannot find anything about this in Microsoft documentation.
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.
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 🙂