sp_dbmmonitorchangemonitoring (Transact-SQL)
Applies to: 
SQL Server
Changes the value of a database mirroring monitoring parameter.
Transact-SQL syntax conventions
Syntax
sp_dbmmonitorchangemonitoring
[ @parameter_id = ] parameter_id
, [ @value = ] value
[ ; ]
Arguments
[ @parameter_id = ] parameter_id
Specifies the identifier of the parameter to be changed. @parameter_id is int, with no default. Currently, only the following parameter is available:
| Parameter | Description of value |
|---|---|
1 |
The number of minutes between updates to the database mirroring status table. The default interval is 1 minute. |
[ @value = ] value
Specifies the new value for the parameter that is being changed. @value is int, with no default.
| Parameter | Description of value |
|---|---|
1 |
An integer in the range of 1 to 120 that specifies a new update period in minutes. |
Return code values
None.
Result set
None.
Permissions
Requires membership in the sysadmin fixed server role, or execute permission directly on this stored procedure.
Examples
The following example changes the update period to 5 minutes.
EXEC sp_dbmmonitorchangemonitoring 1, 5;