4

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.

enter image description here enter image description here

Doug Deden
  • 2,171
  • 10
  • 14
jericzech
  • 977
  • 8
  • 22

1 Answers1

8

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.

Josh Darnell
  • 30,133
  • 5
  • 70
  • 124