• Thanks Gail, I just wanted to post, that I found your articles...to complete it...I found the answers here :

    This Why the DMVS are not a replacement for sql trace[/url] led mo to this Finding the causes of poor performance in sql server[/url] which led me to this A SQL Profiler trace swiss army knife.

    Thanks Gail! Again I didn't se the wood for the trees!

    So this is the way...or is there anything now that makes life easier, f.e. templates for sql nexus, dbdiag or something like retrace which helps with this task? Data Management Warehouse?

    Greetz
    Query Shepherd