Export (0) Print
Expand All
Expand Minimize

sp_dbmmonitorchangemonitoring (Transact-SQL)

Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Changes the value of a database mirroring monitoring parameter.

Applies to: SQL Server (SQL Server 2008 through current version).

Topic link icon Transact-SQL Syntax Conventions

sp_dbmmonitorchangemonitoring parameter
    , value

parameter

Specifies the identifier of the parameter to be changed. Currently, only the following parameter is available:

1 = Update period

The number of minutes between updates to the database mirroring status table. The default interval is 1 minute.

value

Specifies the new value for the parameter that is being changed.

Parameter

Description of value

1

An integer in the range of 1 to 120 that specifies a new update period in minutes.

Requires membership in the sysadmin fixed server role.

The following example changes the update period to 5 minutes.

EXEC sp_dbmmonitorchangemonitoring 1, 5 ;
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft