Post reply

Query to find maxdop of an index

  • September 19, 2014 at 12:38 am

    #311634

    Hello,

    I altered index with maxdop to somevalue (n). What is the query to validate that xyz index has maxdop value set to (n)?

    I tried with GUI. index properties, option and see set maxdop value is 0.

    Regards,

  • September 19, 2014 at 1:43 am

    #1746605

    pawana.paul (9/19/2014)

    Hello,

    I altered index with maxdop to somevalue (n). What is the query to validate that xyz index has maxdop value set to (n)?

    I tried with GUI. index properties, option and see set maxdop value is 0.

    Regards,

    It is under the Option page of the Index Properties.

    😎

  • September 19, 2014 at 3:35 am

    #1746643

    Indexes don't have a MAXDOP.

    What you can do, when rebuilding an index, is specify the maxdop for that rebuild statement, but it's not persistent, it doesn't get stored anywhere, it's only going to affect that specific rebuild statement. Same as the Sort in TempDB option.

    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

  • September 19, 2014 at 1:45 pm

    #1746830

    Hello Gail,

    Thanks for the response.

    Regards,

Viewing 4 posts - 1 through 3 (of 3 total)

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