>>I mean set up a trace but not directly from the Profiler but using T-SQL commands instead. You may try doing it from the SQL Profiler and create a script from the interface.
>
>I do not understand the relation between a trace and obtaining the graphic showed by the execution plan?
Trace will give you other important metrics.
>
>>No, I mean that the DMV hold information only for a certain amount of time (I believe the information is being reset when the server is re-started and may be under some other conditions). So, if you want persistent information, you may want to store the results of DMV into a permanent table.
>>
>>Read about DMVs for better understanding.
>
>Ok
If it's not broken, fix it until it is.
My Blog