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

Advertisements

Instant File Initialization and Database Growths

I just came across a very interesting discovery: instant file initialization is not enabled in our environment. In order to champion its merits to the rest of the team, I needed to set up a way to demonstrate how it could benefit us.
Continue reading