Returns information about warning thresholds on one or all of several key database mirroring monitor performance metrics.
For each returned alert, returns a row containing the following columns:
The following table lists the alert_id value for each performance metric and the unit of measurement of the metric displayed in the sp_dbmmonitorresults result set:
1Oldest unsent transactionMinutes
4Mirror commit overheadMilliseconds
The threshold value for the warning. If a value above this threshold is returned when the mirroring status is updated, an entry is entered into the Windows event log. This value represents KB, minutes, or milliseconds, depending on the warning. If the threshold is currently not set, the value is NULL.
To view the current values, run the sp_dbmmonitorresults stored procedure.
0 = Event is disabled.
1 = Event is enabled.
Retention period is always enabled.
The following example returns a row that indicates whether a warning is enabled for the oldest unsent transaction performance metric on the AdventureWorks database.
EXEC sp_dbmmonitorhelpalert AdventureWorks, 1 ;
The following example returns a row for each performance metric that indicates whether it is enabled on the AdventureWorks database.
EXEC sp_dbmmonitorhelpalert AdventureWorks;