Home Forums SQL Server 2008 T-SQL (SS2K8) Query seems to be constrained by single core CPU in multiple core server - any suggestions? RE: Query seems to be constrained by single core CPU in multiple core server - any suggestions?

  • Without the plan itself (saved & posted as XML as the previous poster said) it's hard to make serious suggestions to you. But, the one thing I can tell you, when you see a pattern with really fat data pipes on the right and really skinny ones on the left, you have a problem. It's probably missing or incorrect indexes or, possibly, out of date statistics. But without the details of information within the plan, that's just guesses.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning