Are My Triggers Being Fired?

The other day my team was asked by a developer to see if his trigger was firing. One person has been working on a Profiler Trace but I thought this would be a good opportunity to raise awareness regarding Extended Events within my team. So while I’m waiting for a good change window to be able to monitor the backup throughput of my VLDB with my backup_restore_throughput XE Session I figured I’d work something up for them.

So I created some simple test tables and triggers
Continue reading