Post reply

Is it possible?

  • February 23, 2009 at 9:50 am

    #131151

    Hi,

    I know we can store the results of profiler trace into a table, but is it possible to do this through sql queries and a scheduled job, without running the profiler it self?

    Thanks,

    Usman

  • February 23, 2009 at 9:59 am

    #948734

    You can create a trace without using profiler. Take a look at sp_trace_create in Books Online.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • February 23, 2009 at 10:58 am

    #948771

    Once the trace has finished, you can then import it into a table using fn_trace_gettable

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • February 23, 2009 at 5:05 pm

    #949084

    Take some help from http://vyaskn.tripod.com/server_side_tracing_in_sql_server.htm

    MJ

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

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