Server utilization and number of rows transfered aren't the problem.  I've seen this issue when moving data from a staging server to production while the rest of our system is...

Saulo,

Thanks for the reply.  I can only assume that the document you referenced must have a bug.  I suspect that it should have said 1 physical and 2 logical under...

Ken,

I can't point you to any whitepaper or KB article that makes recommendations about the Max Degrees of Parallelism (MAXDOP) settings because I've never seen one.  I've learned about MAXDOP...

I appreciate your feeback.  Knowing that you didn't hit a "glass ceiling" induced by hyperthreading on your application server makes me feel a whole lot better about the health of...

Jim,

Thanks for your comments.  I'm very familiar with the "Use all available processors" setting and have found that checking this option produces bad effects in my environment with my workload. ...