Quey plan from profiler

Hi DB gurus,

I was using Profiler to capture query plan, but I could not see the actual plan though. In the EventClass it shows "Show Plan Text" but the data column with TextData is blank.

Can somebody explain how to do this. I am trying to see what query plan is used by sql coming from application.

Any help is highly appreciated.

Thanks
RachaelBetter to use Query Analyzer than profiler.

questions on SQL Profiler

I am using SQL Profiler to monitor one of my database.
The temporary trace file is stored under C:\Documents and Settings\user
\Local Settings\Temp
by default. Is it possible to re-configure it to place to another
location as the file become huge after some time.

ThanksOn Apr 17, 2:26 pm, "akkha1...@.gmail.com" <akkha1...@.gmail.comwrote:

Quote:

Originally Posted by

I am using SQL Profiler to monitor one of my database.
The temporary trace file is stored under C:\Documents and Settings\user
\Local Settings\Temp
by default. Is it possible to re-configure it to place to another
location as the file become huge after some time.
>
Thanks

Are you using SQL 2k or SQL 2k5? In SQL 2005, in the New Trace dialog,
there is a "save to file" option, where you can specify the drive to
log trace data to.

Alternatively, if you're doing the trace programmatically, you can set
a param to denote location to save trace to.

Chadd|||akkha1234@.gmail.com (akkha1234@.gmail.com) writes:

Quote:

Originally Posted by

I am using SQL Profiler to monitor one of my database.
The temporary trace file is stored under C:\Documents and Settings\user
\Local Settings\Temp
by default. Is it possible to re-configure it to place to another
location as the file become huge after some time.

You can change the TEMP and TMP environment variables in the System
applet in the Control Panel. (Under the Advanced tab.)

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||Changing the location of trace file does not serve the purposes.
Changing the TMP is the answer and you have to log off and then login
to make it to be effective for profiler.
Thanks for both of you anyway for the prompt response. Now I know a
bit more about the windows environment.