>>Do you know if or when the trigger was ACTIVATED? It's very hard to see

how deactivating a hungry trigger like that one could *degrade* performance.

I am sorry Helen for confusing you. I've posted DDL for already deactivated trigger which I've deactivated yesterday.

The trigger was firstly activated 21.11.2013 and was active until 15.01.2014, for the whole time server was running without any problems (until the very last few days).We have 5-10 GUI applications connected to the database on daily basis and we have one console application which is importing around 200k new records everyday, and updating another 100k.