Post reply

SQL Profiler doesn't retrieve information...

  • 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

  • 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

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

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