Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server
Returns the current update period.
Transact-SQL syntax conventions
sp_dbmmonitorhelpmonitoring
[ ; ]
None.
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, or execute permission directly on this stored procedure.
The following example returns the current update period.
EXEC sp_dbmmonitorhelpmonitoring;