SQL Server Performance

Tracing a Trigger

Discussion in 'Performance Tuning for DBAs' started by HarryArchibald, Dec 5, 2002.

  1. HarryArchibald New Member

    I am trying to trace what a 3rd party trigger is doing in the database. I can see from the code that is uses temporary tables and updates these using a cursor, which I suspect is making them run slowly. In Profiler I am monitoring all events for TSQL and StoredProcedures but I do not see any SQL from the triggers.

    Has anyone had any success trying to monitor triggers?

  2. sqljunkie New Member

    I'm able to capture them with the SP<img src='/community/emoticons/emotion-7.gif' alt=':S' />tmtCompleted event.<br /><br />The TextData is formatted as follows:<br /><br />-- Trigger Name<br />(Followed by the SQL Code of the Trigger)<br /><br />Find the names of the triggers and look them up in your Profiler trace.<br />
  3. HarryArchibald New Member

    Thanks. That worked a treat.

Share This Page