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?

  • May 8, 2013 at 5:39 am

    #1613287

    caspersql (5/8/2013)

    ChrisM@Work (5/8/2013)

    Can you post the actual execution plan as a .sqlplan attachment please? Makes this kind of exercise much easier.

    This query was so long-running (over 2 days) that I haven't actually seen it complete yet so I just have the estimated, not actual execution plan as of now. After implementing Eugene's suggestions I'll post up the actual if the query actually ever finishes for me...

    In the meantime, here is the estimated plan. The table names are proprietary so I'm posting the execution plan as a jpeg with the names blocked out, does that suffice? All that's blocked out is the table name which I've callled 'SourceTable' above. That is the table that joins on itself several times.

    Note that my example code above was simplified somewhat. There is a coalesce, group by and order by in the actual statement.

    Unfortunately, I cannot see anything attached. Anyway, JPG is not very good idea for posting query plan. You better save it as XML. You need to post complete query if you want relevant help. Also, posting DDL of involved database objects would be helpful.

    _____________________________________________
    "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]