SQL Server Performance

Profiling Trigger activity

Discussion in 'Performance Tuning for DBAs' started by mgrogan, Dec 11, 2002.

  1. mgrogan New Member

    How do you set up profiler to trace activity of a trigger in SQL Server 7? <br /><br />I've set my ObjectID filter equal to the Object ID of the trigger and database filter equal to the correct database ID. I then set TSQL Events equal to SQL<img src='/community/emoticons/emotion-7.gif' alt=':S' />tmtCompleted. I still get just about every TSQL event in the database. In fact, if I set up the profiler to test for the opening of the table that holds this trigger I get every object opened in the database.<br /><br />How do I set up profiler to only filter on one object or trigger?
  2. sqljunkie New Member

    When I monitored triggers in profiler they were showing up in the textdata as follows

    -- Trigger Name
    (Followed by the SQL Code of the Trigger)

    You may want to set a filter on Textdata like "-- Your Trigger Name" to see if you can capture the triggers only...
  3. bradmcgehee New Member

    See this previous post "Tracing a Trigger".


    ------------------
    Brad M. McGehee
    Webmaster
    SQL-Server-Performance.Com
  4. mgrogan New Member

    Thanks for the help. Can I also set the SP<img src='/community/emoticons/emotion-7.gif' alt=':S' />tmtCompleted Event and filter on the trigger's object ID or is it better to filter on the text data "-- Trigger Name"
  5. sqljunkie New Member

    I don't see how tracing on the ObjectID or the textdata would matter. Do either one that gets you the data you're looking for...
  6. mgrogan New Member

    Thanks for all the help.

Share This Page