March 6, 2012 at 2:43 pm
Usually i would use 'Showplan XML statistics profile' inside profiler trace to get the execution plan but this time i need to use in different form by using the option 'Showplan Statistics Profile ' since the first one had limitation. My question is i populated all this data into a table, i am not able to interpret the results for 'Showplan Statistics Profile ', with the first one i could have easily looked at the execution plan and that would give me an idea on which process is taking is most cost. How do i do the same with the second option?
March 7, 2012 at 9:34 pm
sqldba_newbie (3/6/2012)
...My question is i populated all this data into a table, .... How do i do the same with the second option?
sys.dm_exec_query_plan DMV gives cached plans in XML format. When you click the XML link, you get the query plan in graphical format.
In graphical format you can see the cost and other details much easily.
March 8, 2012 at 3:54 pm
Suresh B. (3/7/2012)
sqldba_newbie (3/6/2012)
...My question is i populated all this data into a table, .... How do i do the same with the second option?sys.dm_exec_query_plan DMV gives cached plans in XML format. When you click the XML link, you get the query plan in graphical format.
In graphical format you can see the cost and other details much easily.
This is all in table as i mentioned
March 8, 2012 at 9:01 pm
Grant Fritchey has written a nice book on interpreting query plan.
Please download and read it. It is free:
March 9, 2012 at 9:50 am
Suresh B. (3/8/2012)
Grant Fritchey has written a nice book on interpreting query plan.Please download and read it. It is free:
I do have a hard copy of his book. Let me take a look at it. Thanks
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply