Post reply

Delay Between Triggers

  • June 2, 2005 at 11:44 am

    #87896

    Using SQL Server Profiler and using strategically placed "Print" statements, I have identified a situation where multiple triggers are firing as part of an update to a table.  After one trigger completes its processing, there is a delay of several seconds (usually between 5 and 11 seconds) between the firing of the next trigger.  Does anyone have any thoughts as to what might cause such a thing?

    Thanks for your assistance!

  • June 3, 2005 at 3:07 am

    #562809

    Usually, this will happen if you have some huge datatype in your table.

    Kindest Regards,

    R

  • June 3, 2005 at 9:07 am

    #562944

    What does the trigger do that causes the delay?

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

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