Obtain the query plan of a running process

[Thyagu]

Hi,

Is there a way to findout the query plan of the executing process using
the SPID/KPID information.

Thanks in advance,
Thyagu.D

[Jack Vamvas]

Re: Obtain the query plan of a running process

One way to do this task is: Set up a Profile Trace and add Show Plan
event , save the info , and filter with the SPID


----
Jack Vamvas
_______________ _______________ _____
Receive free SQL tips - www.ciquery.com/sqlserver.htm
Make SQL Server faster - www.quicksqlserver.com
_______________ _______________ _____


"Thyagu" <tdelli@gmail.c omwrote in message
news:1158834419 .604983.220140@ m7g2000cwm.goog legroups.com...

Hi,
>
Is there a way to findout the query plan of the executing process using
the SPID/KPID information.
>
Thanks in advance,
Thyagu.D
>