How do I determine the server's MAXDOP setting in SQL Server?

Question

I see lots of sites that show how to set it, but I just want to see what it is first. What is the command to do this?

Answer 1

More simply if you wish to use a pure SQL script you can use the following which will give you the values for both 'cost threshold for parallelism' and 'max degree of parallelism' or many other things if you remove the WHERE clause ;)

SELECT
    name,
    value_in_use
FROM
    sys.configurations
WHERE
    description LIKE '%parallelism%'