Yes. I/o, Memory, CPU intensive SPs. Identified by Profiler trace top 50 most often executed SPs with longest duration, and I started to optimize them, which included not only TSQL modifications here and there but also creating a few dozen of indexes thanks to analysis of Query Plans. So what I need to do is to show management that my optimization changes actually have made a difference. So I am just asking if there is something good to rely on in addition to Profiler Traces and there analysis (SQL 2008). It is my understanding that info provided via for example sys.dm_qry_stats DMV is not really reliable (being cumulative, dependent on reboot, etc.). So I was wondering if someone possibly used other metrics than profiler traces to show "before" and "after rollout of optimizing scripts.