I’m trying to get the current max degree of parallelism in a database so I came across two ways of doing it the problem is I get different results

When I run

SELECT value_in_use FROM sys.configuration WHERE description LIKE '%max%%parallelism%'

I get

0

But when I run

SELECT value FROM sys.database_scoped_configurations WHERE name = 'MAXDOP'

I get

8

Why do I get different results? What are the differences between them?

As a side note, I’ve been taking a look at this because of the N limit issue