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.