Post reply

Do DDL triggers cause any considerable performance impact ?

  • December 14, 2014 at 11:06 pm

    #299418

    Hi,

    Do DDL triggers cause any considerable performance impact ?

    Thanks,

    Smith.

  • December 15, 2014 at 2:36 am

    #1764663

    Dear Joy,

    Triggers always have a performance impact as they will keep you transaction open till their execution is completed. It does not matter whether it is DDL or DML trigger.

    However Triggers performs a wonderful job when it comes to certain functionality as in data consistency or implementing business logic.

    Trade off is always their, It is just the matter of your Unique requirement that will decide whether or not to use them.

    Hope it helps..!!

    Regards

    Shafat Husain

    Regards,
    Shafat Husain
    🙂
    And Your Lord Never Forgets...!! (64:19 -- Quran)

  • December 15, 2014 at 2:52 am

    #1764666

    Depends what they do.

    However, since DDL triggers only fire on DDL operations, unless you're changing the schema every few seconds, it shouldn't have a major effect.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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