Post reply

max degree of parallelism change

  • March 28, 2012 at 2:34 am

    #270920

    hi,

    I've sql 2005 with latest SP on HP server with the Intel E5645 Processor that have 6 Cores and 12 Threads per CPU and i have 2 CPU on server (with hyper threading enabled).

    i experience some slow running query and after i run dbcc freeproccache and dbcc dropcleanbuffers the query start to run fine.

    my question is - what number do i need to setup on the max degree of parallelism with the CPU that i have on the server?

    THX

  • March 28, 2012 at 4:23 am

    #1465568

    The sure way to know the effect of MAXDOP setting is to test against your workload that involves parallel queries/operations. But for general guidelines, I would recommend this KB. This will give you more insight.

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

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