I made a trigger that activates every time an insert, update or delete has been made on a certain table. I have already implemented it into the tables in one of our servers.
I now need to know if that many triggers will have an impact in my server's memory Is it possible to capture how much memory is a trigger consuming?