sys.sp_dbmmonitoraddmonitoring

Description

Creates a database mirroring monitor job that periodically updates the mirroring status for every mirrored database on the server instance. Specifies the interval between updates in minutes. , with a default of This value can be from 1 to 120 minutes. If update period is set too low, the response time might increase for clients.

Syntax

sp_dbmmonitoraddmonitoring [ [ @update_period = ] update_period ]
[ ; ]

Remarks

Creates a database mirroring monitor job that periodically updates the mirroring status for

every mirrored database on the server instance.

Specifies the interval between updates in minutes.

@update_period

, with a default of

This value can be from 1 to 120 minutes.

If update period is set too low, the response time might increase for clients.

Examples

Example 1

sp_dbmmonitoraddmonitoring

Example 2

ALTER DATABASE

Example 3

sp_dbmmonitoraddmonitoring

Example 4

3

Example 5

sp_dbmmonitoraddmonitoring

Example 6

EXECUTE sp_dbmmonitoraddmonitoring 3;