Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

sp_dbmmonitorchangemonitoring (Transact-SQL)

Changes the value of a database mirroring monitoring parameter.

Topic link iconTransact-SQL Syntax Conventions



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.


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


Description of value


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

© 2015 Microsoft