Query Profiler trace log software

• hummer9595

  Valued Member

  Points: 61

  More actions

  February 16, 2004 at 10:36 am

  #161626

  I am looking for a way to log all events that occur on the server. I have used quary profier and that gets me the info i need but is there a way to truncate the file, say only log the last 30 minutes of activity and having it rolling so that it is always the last 30 minutes. Or is there some other software that will do this. The database times out at random times and I am trying to fix the problem but dont want to keep houndreds of log files that query profiler will create by leaving a trace running 24/7. Any suggestions.

  Thanks

  Mark

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736479

  More actions

  February 16, 2004 at 3:03 pm

  #494264

  You can set the files to rollover after a certain # of MB. You could get look at your files and see what 30 minutes looks like and rollver there.

  You still would need a way to clean up after a certain amount of time, but a VB script would do that.