hajduk1908

Question of the Day

Which MAXDOP?

I have a SQL Server 2022 instance with this setting:

EXECUTE sp_configure 'max degree of parallelism', 4;
GO

I then run this:

SELECT ProductID, OrderQty, SUM(LineTotal) AS Total
FROM Sales.SalesOrderDetail
WHERE UnitPrice < $5.00
GROUP BY ProductID, OrderQty
ORDER BY ProductID, OrderQty
OPTION (MAXDOP 2);
GO

What is the maxdop for my query?

See possible answers