sys.sp_dbmmonitorhelpmonitoring
general #stored-procedure
Description
Returns the current update period. 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. fixed server role, or execute permission directly on this The following example returns the current update period.
Syntax
sp_dbmmonitorhelpmonitoring
[ ; ]
Examples
Example 1
sp_dbmmonitorhelpmonitoring
[ ; ]
Example 2
EXECUTE sp_dbmmonitorhelpmonitoring;