>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?
>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