SQL Profiler doesn't retrieve information...

• boussekey

  SSC Veteran

  Points: 216

  More actions

  March 7, 2003 at 10:02 am

  #58342

  Hello,

  I have a trace which runs correctly for more than a month on my production server.

  I've tried to add event_ids, and it now returns nothing. I've add the following events:

  * deadlock

  * transaction

  I first tried by the script generated by SQLProfiler and that I use in my stored procedure to launch the trace, and then I tried to generate a new script thanks to SQLProfiler. The two methods gave no results

  I have also tried to add the columns NestLevel and LockMode.

  My server is in SQL2000sp2 + hot fix slammer

• March 10, 2003 at 8:00 am

  This was removed by the editor as SPAM

• boussekey

  SSC Veteran

  Points: 216

  More actions

  March 11, 2003 at 4:23 am

  #450770

  For your information,

  I remarked that when SQL is running a trace the events are stocked in a buffer and the file is not updated "in-live" as in SQL-Profiler.

  Everything is OK

  Tom