Post reply

Edit rollove size threshold in SQL Server profiler trace

  • December 29, 2011 at 4:07 pm

    #252792

    Can anyone please advise how to change the rollover size threshold for an existing SQl Profiler trace?

  • December 29, 2011 at 4:26 pm

    #1426742

    the @maxfilesize (4th) parameter in Stored proc sp_trace_create

    ---------------------------------------------------------------------

  • December 29, 2011 at 5:32 pm

    #1426749

    Can I use that sproc for an already existing trace?

  • December 30, 2011 at 2:57 am

    #1426816

    what do you mean already existing? Do you have a perpetually running server side trace?

    I would stop the current trace and restart it with the changed parameter.

    ---------------------------------------------------------------------

  • December 30, 2011 at 2:58 am

    #1426817

    No, you'll need to stop and delete the trace and then recreate it.

    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

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

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