SQLTeam.com | Weblogs | Forums

Actual execution plan from dmv


#1

Hi,
Could anyone tell me how do I get actual from DMV. I requested for DBA for actual plan to analyse the slow perforamce of SP the DBA said her has taken from DMV but he is not interested to give more details.Hope anyone from here could help me to get teh answer.

Regards,
Shaggy


#2

Check this out: http://stackoverflow.com/questions/7359702/how-do-i-obtain-a-query-execution-plan. Also add Extended Events to the list of ways to get the actual plan.