Monday, March 12, 2012

How to set SQL Profiler via command line

Hello,
How can I set SQL Profiler to capture the logs via command line? I wanted to
this just before my testing.
This is what I have:
I already have a SQL Profiler Template (fooTemplate.tdf) which tells what I
need SQL to capture.
C:\>"C:\Program Files\Microsoft SQL Server\90\Tools\Binn\PROFILER90.EXE"
/Sfoo /Dfoo /E /T"c:\fooTemplate.tdf" /Oc:\mysql.out
What other parameters am I missing?
Thanks!
Read the below article about server side tracing.
http://vyaskn.tripod.com/server_side_tracing_in_sql_server.htm
http://www.dbazine.com/sql/sql-articles/larsen6
THanks
Hari
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OThA6%23tZHHA.1388@.TK2MSFTNGP05.phx.gbl...
> Read up on "Server Side Trace".
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "MS" <MS@.discussions.microsoft.com> wrote in message
> news:301D495F-1B3F-4694-B9CA-6A3417F7CDEF@.microsoft.com...
>
|||On 15 Mar, 14:14, "Hari Prasad" <hari_prasa...@.hotmail.com> wrote:
> Read the below article aboutserverside tracing.
> http://vyaskn.tripod.com/server_side_tracing_in_sql_server.htm
> http://www.dbazine.com/sql/sql-articles/larsen6
> THanks
> Hari
> "Tibor Karaszi" <tibor_please.no.email_kara...@.hotmail.nomail.com> wrote in
> messagenews:OThA6%23tZHHA.1388@.TK2MSFTNGP05.phx.gb l...
>
>
>
>
>
>
> - Show quoted text -
That was very useful.. Thanks hari..
-PrasannaKRao

No comments:

Post a Comment