Post reply

suggestion plz

  • March 26, 2009 at 6:17 am

    #201596

    I wrote a DDL trigger for database , while alter,drop,create table..

    is it reduce the performance of database?

    give me your suggestion plz

  • March 26, 2009 at 6:35 am

    #966581

    This depends on the trigger’s code. For example if inside the trigger you wrote something like that:

    Waitfor delay '00:05:00'

    You can expect a huge degradation. Without knowing the code no one can say for sure if there is any performance hit, but I have to admit that you have to write a very strange code in the trigger if it will cause the create/drop/alter statement run very slow.

    Adi

    --------------------------------------------------------------
    To know how to ask questions and increase the chances of getting asnwers:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • March 26, 2009 at 10:31 am

    #966833

    Hi

    I don't think that a database trigger would affect the operative performance of your system.

    Greets

    Flo

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

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