Post reply

View value in place for "Max Degree of Parallelism" (query)

  • April 4, 2011 at 8:51 am

    #234166

    Hi All, I wanted to know if anyone knows a query, that will let me know what option I have set in this field.

    Thanks!

  • April 4, 2011 at 8:55 am

    #1307024

    EXEC sp_configure 'max degree of parallelism'

  • April 4, 2011 at 9:01 am

    #1307028

    Thank you howard...is there anyway to just return the value set? i.e '1' in my case?

  • April 4, 2011 at 9:13 am

    #1307037

    I'm not aware of a system view that shows the value, so think you'd have to insert the results of the procedure into a temp table to do this. E.g.:

    CREATE TABLE #Options (NAME VARCHAR(255), minimum INT, maximum INT, config_value INT, run_value INT)

    INSERT INTO #Options

    EXEC sp_configure 'max degree of parallelism'

    SELECT run_value FROM #Options

    WHERE name='max degree of parallelism'

  • April 4, 2011 at 9:23 am

    #1307047

    SELECT value_in_use

    FROM sys.configurations

    WHERE name = 'max degree of parallelism'

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • April 4, 2011 at 9:28 am

    #1307052

    Thanks Gail - wasn't aware of that system view!

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply