Post reply

Profiler trace

  • March 17, 2012 at 1:29 am

    #253300

    There is no option to create a trace in MSSQL express so,

    How could i create a trace in MSSQL express edition.

    will there any performance slowdown issue happen after tracing?

    Thanks & Regards,
    Pallavi

  • March 17, 2012 at 1:47 am

    #1460840

    the only scenario I can think of where you would face performance issues after a trace if the Trace has taken up a lot of disk space as part of the logging process. This generally happens if you haven't configured limits for the trace.

    What are you trying to find using the the trace , there are other options like looking at the execution plan or system monitor available too.

    Jayanth Kurup[/url]

  • March 17, 2012 at 1:55 am

    #1460843

    I want to trace the all information of which user is doing what kind of work in MSSQL environment.. it's a kind of user log history..

    Thanks & Regards,
    Pallavi

  • March 17, 2012 at 2:00 am

    #1460844

    Try using a DDL Trigger.

    http://msdn.microsoft.com/en-us/library/ms186406.aspx

    Jayanth Kurup[/url]

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

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