Post reply

Max Degree of Parallelism Question

  • July 26, 2011 at 4:28 am

    #240574

    I have a new server running SQL Server 2008 R2. I keep reading various opinions on the Max Degree of Parallelism setting and I'm pretty confused as to what the setting should be on a newly built server. SQL is seeing 24 CPUs from a 2 Processor Server.

    Can I get some opinions as to what I should set it to?

  • July 26, 2011 at 4:57 am

    #1358357

    Keep MAXDOP as its default value unless there is system specific requirement for this.

    Ryan
    //All our dreams can come true, if we have the courage to pursue them//

  • July 26, 2011 at 5:21 am

    #1358372

    If your workload is more OLAP than OLTP you may want more parallelism on your machine. If you have a lot of transactions / processes waiting on CXPACKET etc you may want to review - either at the server level or at the individual query level with query hint OPTION(MAXDOP=n)

  • July 26, 2011 at 5:23 am

    #1358374

    Thanks guys.

    Yes I'm aware of OLAP v OLTP. I was more wondering towards whether anyone has a standard or best practice for a completely new server where you don't necessary know what the load is going to be.

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

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