Sample Header Ad - 728x90

No parallelism in Express Edition of SQL Server

4 votes
1 answer
942 views
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
Asked by jericzech (977 rep)
Apr 16, 2021, 09:55 AM
Last activity: Apr 16, 2021, 05:28 PM