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

I see lots of sites that show how to set it, but I just want to see what it is first. What i开发者_Python百科s the command to do this?

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 ;)

Edited the following to limit to one row

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

In Script:

EXEC sp_configure 'show advanced options', 1
GO
RECONFIGURE
GO
EXEC sp_configure 'max degree of parallelism'
GO