Returns the current update period.
Transact-SQL Syntax Conventions
sp_dbmmonitorhelpmonitoring
None
Returns the current update period, that is, the number of minutes between updates of database mirroring status table. This value ranges from 1 to 120 minutes.
Requires membership in the sysadmin fixed server role.
The following example returns the current update period.
EXEC sp_dbmmonitorhelpmonitoring;