Adds some overhead to each transaction. How much depends on what the trigger does. Not a reason to not use them, but definitely should be used wisely, in context. In some cases a very "heavy" trigger might be perfectly ok because there are few concurrent users.