SQL Server Monitoring – Triggers

Published January 26, 2022.


To show the configured triggers.


This feature queries the DMV sys.triggers which returns information for database and table triggers.


The report page Triggers has a table showing each configured trigger.


The model for the report uses the fact [Triggers] and the dimension [Database].


The feature accept the parameter @Databases and the syntax is the same that is used in the SQL Server Index and Statistics Management solution made by Ola Hallengren.

The default parameter for the feature is “@Databases = ‘USER_DATABASES, msdb'”

SYSTEM_DATABASESAll system databases (master, msdb, model, and tempdb)
USER_DATABASESAll user databases
ALL_DATABASESAll databases
Db1The database Db1
Db1, Db2The databases Db1 and Db2
USER_DATABASES, -Db1All user databases, except Db1
%Db%All databases that have “Db” in the name
%Db%, -Db1All databases that have “Db” in the name, except Db1
ALL_DATABASES, -%Db%All databases that do not have “Db” in the name


The default schedule for the feature is once every day between 22:00 and 23:00.


The default retention for the table dbo.fhsmTriggers is 30 days.