Post reply

Finding execution plan of a specific running process

  • August 31, 2006 at 4:18 am

    #61722

    Hi all,

          We can use "set showplan text" or "set showplan all" to find the execution plan of a query. But what if we are only given the process ID? Is there any way to retrieve the execution plan of a process ID (even showing the execution plan of a process which is executing a stored procedure)?

    Thanks,

    Del Piero

     

     

  • August 31, 2006 at 8:26 am

    #657821

    You can get the execution plan from a Profiler trace by process ID.  If you run Profiler and include the Performance: Execution Plan event, you will be able to look at all queries and their corresponding execution plans for a given process ID.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply