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;