Showing posts with label tothis. Show all posts
Showing posts with label tothis. Show all posts

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