Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Trigger Issue... RE: Trigger Issue...

  • September 17, 2013 at 6:01 am

    #1650755

    I ran SQL Profiler on the GCP_VND_ActualizaDocumentoVenda_LinhasDocStatus procedure with all the events and data checked...

    I've a big table to analyse but I don't know what to search for... It even has the execution plans...

    But still I noticed:

    The SUM of Duration inside the trigger is 440 (EventClass 45 and 43 for the INSERT) and the Duration of the INSERT that fires the trigger is 1173 (EventClass 45).

    ?!?!

    With the trigger disabled the GCP_VND_ActualizaDocumentoVenda_LinhasDocStatus procedure duration is 188, that is "close" the the 200 from the duration with the trigger enabled.

    Thanks,

    Pedro


    If you need to work better, try working less...