how maxdop works?need reply with detail

• sanketahir1985

  SSCarpal Tunnel

  Points: 4473

  More actions

  August 4, 2009 at 12:52 am

  #385109

  Hi friends

  I wanted to know how MAXDOP works,in detail.

  My system contains 32GB RAM, 8CPU & DOP is set to 0(Default)

  now,

  If i m having select query which runs continuously (from multiple users )

  which increases waits on server

  now my doubt is ,if i m supplying 8 CPUs for those quries,logically it should execute quickly.

  if MAXDOP is set to 4, how will the query performance be better than the prev. settings,

  even if it is taking lesser no. of CPUs?

  i want detailed ans, if possible with example.

  also i have uploaded some reports kindly go through it &

  Plzzzzzzzz reply on this

  Sanket Ahir
  Don't run behind the success, Try to be eligible & success will run behind u......

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  August 4, 2009 at 8:41 am

  #1034310

  Duplicate post. Please reply here.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question