Apex Trigger Analyzer from Bounteous

The Apex Trigger Analyzer from Bounteous helps your team automatically detect all the active, inactive, invalid triggers per object. It also detects duplicate events and hardcoded Salesforce IDs.

Enhanced features in the app include:

• Loop DMLs/Queries: Salesforce has a governor limit that enforces a maximum number of SOQL queries and DML statements, the app will detect when you reach the governor limit.
• SOQL Statistics: If a trigger contains queries without SOQL this may trigger 50,000+ records in production instances and hit the governor limits. The app provides information about the count of queries with/without "WHERE" clauses to solve this issue.