Post reply

Max Degree of parallellism

  • September 11, 2012 at 3:58 am

    #266463

    Good Day, we received instruction from a large developing company to set the cpus to max degree of parallellism to 1 on an SQL Server 2008R2 64 bit Ent edition with 4 processors and 8 gig of memory . Could this setting not degrade performance even further ?

  • September 11, 2012 at 4:00 am

    #1536099

    lianvh (9/11/2012)

    Good Day, we received instruction from a large developing company to set the cpus to max degree of parallellism to 1 on an SQL Server 2008R2 64 bit Ent edition with 4 processors and 8 gig of memory . Could this setting not degrade performance even further ?

    Is your SQL Server a Virtual Server?



    My blog

  • September 11, 2012 at 4:01 am

    #1536101

    Yes, they are

  • September 11, 2012 at 4:03 am

    #1536104

    Tell them that's the biggest load of hogswash you've heard and they should kindly update their 'best practices' from ones used 10 years ago. 🙂

    Seriously though, no, that's not a good recommendation (neither's the other one that you mentioned here). It used to be 'recommended' some years back, but it wasn't the best even then.

    It's touched on in this article and there are links to further details https://www.simple-talk.com/sql/database-administration/gail-shaws-sql-server-howlers/

    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 11, 2012 at 4:19 am

    #1536115

    lianvh (9/11/2012)

    Good Day, we received instruction from a large developing company to set the cpus to max degree of parallellism to 1 on an SQL Server 2008R2 64 bit Ent edition with 4 processors and 8 gig of memory . Could this setting not degrade performance even further ?

    Just this? Thanks God, they didn't ask you to migrate to MS Access...

    It's like renting the Ferrari with limiting yourself to 40 miles per hour on motorways.

    That would really impress girls ...

    :hehe:

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

  • September 11, 2012 at 4:27 am

    #1536125

    Yes, you can say that again

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

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