Blitz Result: Triggers Found on Tables

Lemme start out by saying we don’t have a problem with triggers in general.  Triggers can be an easy, bulletproof way to enforce business logic in the database tier.  Unfortunately, they don’t always scale well – especially when we try to perform a lot of row-by-row logic inside the triggers.

This part of our SQL Server sp_Blitz script checks sys.triggers in each database.

To Fix the Problem

Script out each trigger to understand what it’s doing.  Make sure it handles multiple records successfully – most don’t.  Generally speaking, we can’t rip triggers out right away, but we at least want to be aware that they’re around when we try to do performance tuning or why we’re troubleshooting record insert/update issues.

Return to sp_Blitz or Ask Us Questions